-- STATSUAT.AAIS_STAT_AU definition

-- DDL generated by DBeaver
-- WARNING: It may differ from actual native database DDL

-- Drop table

-- DROP TABLE STATSUAT.AAIS_STAT_AU;

CREATE TABLE STATSUAT.AAIS_STAT_AU (
	ID NUMBER(38,0),
	TRANSMITTAL_ID NUMBER(38,0),
	CHANGE_COMMENTS VARCHAR2(4000),
	UPDATED_BY NUMBER(38,0),
	EFF_START_DATE TIMESTAMP,
	EFF_END_DATE TIMESTAMP,
	LAST_VALIDATED_DATE TIMESTAMP,
	STATUS VARCHAR2(20),
	LINE_NUMBER NUMBER(38,0),
	VERSION NUMBER(38,0) DEFAULT 1,
	VAL_VER NUMBER(38,0) DEFAULT 1,
	REP_YR_4DIGIT NUMBER(4,0),
	LINE VARCHAR2(2),
	REP_MO VARCHAR2(2),
	REP_YR VARCHAR2(1),
	COMP VARCHAR2(4),
	STATE VARCHAR2(2),
	TERRITORY VARCHAR2(3),
	OPT_ZIP_CD_IND VARCHAR2(1),
	TRANS VARCHAR2(1),
	PREM_AMT NUMBER(12,2),
	LOSS_AMT NUMBER(12,2),
	PROG_CD VARCHAR2(1),
	COV_CODE VARCHAR2(1),
	SUBLINE VARCHAR2(1),
	RES030 VARCHAR2(4),
	AGE VARCHAR2(1),
	SEX_MARITAL VARCHAR2(1),
	VEHICLE_USE VARCHAR2(1),
	VEHICLE_PERF VARCHAR2(1),
	COMMERCIAL_CLASS VARCHAR2(1),
	DRIV_TRAIN_GOOD_STUDENT VARCHAR2(1),
	COMMERCIAL_USE VARCHAR2(1),
	PENALTY_POINTS VARCHAR2(1),
	LIA_LIM VARCHAR2(1),
	DED_AMT VARCHAR2(1),
	BODY_STYLE VARCHAR2(2),
	BODY_SIZE VARCHAR2(1),
	MODEL_YEAR VARCHAR2(2),
	UM_UIM_MOTORIST VARCHAR2(1),
	EXPOSURE NUMBER(38,0),
	CLM_CNT NUMBER(38,0),
	COL VARCHAR2(1),
	MOS_COV VARCHAR2(2),
	RES050 VARCHAR2(1),
	TERRORISM VARCHAR2(1),
	RES051 VARCHAR2(1),
	RES052 VARCHAR2(4),
	SING_MULT_CAR VARCHAR2(1),
	ACCIDENT_MON VARCHAR2(2),
	RES057 VARCHAR2(3),
	ACCIDENT_YR VARCHAR2(2),
	RES060 VARCHAR2(4),
	PACKAGE_ID VARCHAR2(1),
	POOL VARCHAR2(1),
	CLAIM_NUM VARCHAR2(12),
	POLICY_NUM VARCHAR2(14),
	CLAIM_ID VARCHAR2(2),
	RES080 VARCHAR2(1),
	ZIP VARCHAR2(5),
	ZIP_SUFF VARCHAR2(4),
	UM_UIM_STACK_IND VARCHAR2(1),
	RES091 VARCHAR2(2),
	SYMBOL VARCHAR2(2),
	PASS_RESTRAINT VARCHAR2(1),
	ANTI_LOCK VARCHAR2(1),
	ANTI_THEFT VARCHAR2(2),
	DEF_DRIVER VARCHAR2(1),
	PIP_LIMIT_DED VARCHAR2(1),
	NJ_PIP_LIMIT VARCHAR2(2),
	RES099 VARCHAR2(2),
	NJ_PIP_DED VARCHAR2(1),
	RAT_TERM_ZONE VARCHAR2(3),
	RES101 VARCHAR2(3),
	ASSIGN_RISK_RATE_CLASS VARCHAR2(4),
	ASSIGN_RISK_PTS_SUR VARCHAR2(2),
	EXP_RATING_MOD VARCHAR2(3),
	RES111 VARCHAR2(2),
	RES113 VARCHAR2(1),
	EXCEPT_A VARCHAR2(2),
	EXCEPT_B VARCHAR2(2),
	EXCEPT_C VARCHAR2(2),
	EXCEPT_D VARCHAR2(2),
	RES122 VARCHAR2(15),
	COUNTY VARCHAR2(3),
	CO_USE VARCHAR2(11),
	NOTES VARCHAR2(4000),
	VIN VARCHAR2(17),
	LIMIT_LOSS_CD_ID VARCHAR2(1),
	CONSTRAINT PK_AAIS_STAT_AU PRIMARY KEY (ID),
	CONSTRAINT SYS_C0015348 CHECK ("ID" IS NOT NULL),
	CONSTRAINT SYS_C0015349 CHECK ("TRANSMITTAL_ID" IS NOT NULL),
	CONSTRAINT SYS_C0015350 CHECK ("EFF_END_DATE" IS NOT NULL),
	CONSTRAINT FK_AAIS_STAT_AU_TRANSMITTAL FOREIGN KEY (TRANSMITTAL_ID) REFERENCES STATSUAT.TRANSMITTAL(ID) ON DELETE CASCADE
);
CREATE INDEX IDX_AAIS_STAT_AU_TRANS_ID ON STATSUAT.AAIS_STAT_AU (TRANSMITTAL_ID);
CREATE UNIQUE INDEX PK_AAIS_STAT_AU ON STATSUAT.AAIS_STAT_AU (ID);