| id |
bigint(20)
|
|
|
|
| policy_uuid |
char(36)
|
ascii_bin
|
|
|
| branch_id |
int(10)
|
|
|
|
| policy_version |
int(10)
|
|
|
|
| policy_status |
enum('DRAFT', 'ACTIVE', 'RETIRED')
|
utf8mb4_unicode_ci
|
|
|
| effective_from |
date
|
|
|
|
| effective_to |
date
|
|
|
|
| proration_method |
enum('CALENDAR_DAYS', 'WORKING_DAYS', 'FIXED_30_DAYS', 'NO_PRORATION')
|
utf8mb4_unicode_ci
|
|
|
| fixed_days_divisor |
decimal(8,2)
|
|
|
|
| rounding_mode |
enum('HALF_UP', 'HALF_EVEN', 'DOWN', 'UP')
|
utf8mb4_unicode_ci
|
|
|
| rounding_scale |
tinyint(3)
|
|
|
|
| policy_hash |
char(64)
|
ascii_bin
|
|
|
| lock_version |
int(10)
|
|
|
|
| notes |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| created_by |
bigint(20)
|
|
|
|
| updated_by |
bigint(20)
|
|
|
|
| approved_by |
bigint(20)
|
|
|
|
| approved_at_utc |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|