drop table LA_COURSE;

drop table LA_CRS_HISTORY;

drop table LA_FLYER;

drop table LA_GOLDEN_SAMPLE;

drop table LA_MESSAGE;

drop table LA_PAPER;

drop table LA_QUESTION;

drop table LA_QUIZ;

drop table LA_QUIZ_RECORD;

drop table LA_RECORD;

drop table LA_RL_HISTORY;

drop table LA_ROLE;

drop table LA_USER;

create table LA_COURSE (

CRS_ID SERIAL not null,

CRS_NAME varchar not null,

CRS_PRICE float not null,

CRS_URL varchar null,

CRS_STARTDATE DATE null,

CRS_ENDDATE DATE null,

CRS_ACTIVE BOOL not null,

constraint PK_LA_COURSE primary key (CRS_ID)

);

create table LA_CRS_HISTORY (

HSTR_USR_ID varchar not null,

HSTR_CRS_ID int not null,

HSTR_UPDATE_TIME TIMESTAMP not null

);

create table LA_FLYER (

FLR_ID SERIAL not null,

FLR_CONTENT VARCHAR not null,

FLR_ACTIVE_TIME TIMESTAMP not null,

FLR_AUDIENCE_TYPE VARCHAR(1) not null,

FLR_AUDIENCE_LIST VARCHAR not null,

FLR_ACTIVE BOOL not null,

FLR_UPDATE_TIME TIMESTAMP not null,

constraint PK_LA_FLYER primary key (FLR_ID)

);

create table LA_GOLDEN_SAMPLE (

SMPL_ID SERIAL not null,

SMPL_NAME varchar not null,

SMPL_RL_ID int not null,

SMPL_MANDATORY varchar not null,

SMPL_OPTIONAL varchar not null,

SMPL_UPDATE_TIME TIMESTAMP not null,

SMPL_ACTIVE BOOL not null,

constraint PK_LA_GOLDEN_SAMPLE primary key (SMPL_ID)

);

create table LA_MESSAGE (

MSG_ID SERIAL not null,

MSG_USER_ID VARCHAR not null,

MSG_CONTENT VARCHAR not null,

MSG_SESSION INT4 not null,

MSG_LEVEL INT4 not null,

MSG_SERIAL INT4 not null,

MSG_CREATE_DATE TIMESTAMP not null,

MSG_ACTIVE BOOL not null,

MSG_INTENT VARCHAR null,

MSG_ACTION VARCHAR null,

constraint PK_LA_MESSAGE primary key (MSG_ID)

);

create table LA_PAPER (

PPR_ID SERIAL not null,

PPR_QUZ_ID INT4 not null,

PPR_USR_ID VARCHAR not null,

PPR_CONTENT VARCHAR not null,

PPR_STANDARD VARCHAR not null,

PPR_ANSWER VARCHAR not null,

PPR_UPDATE_TIME TIMESTAMP not null,

PPR_SCORE INT4 null,

PPR_TOTAL INT4 not null,

PPR_INDEX INT4 not null,

PPR_SESSION TIMESTAMP not null,

PPR_ACTIVE BOOL not null,

constraint PK_LA_PAPER primary key (PPR_ID)

);

create table LA_QUESTION (

QUST_QUIZ_ID int4 not null,

QUST_SUBJECT varchar not null,

QUST_CHOICES varchar not null,

QUST_ANSWER varchar not null,

QUST_NUMBER int4 not null

);

create table LA_QUIZ (

QUZ_ID SERIAL not null,

QUZ_CRS_ID int4 not null,

QUZ_ACTIVE_TIME TIMESTAMP not null,

QUZ_AUDIENCE_TYPE VARCHAR(1) not null,

QUZ_AUDIENCE_LIST VARCHAR not null,

QUZ_ACTIVE BOOL not null,

QUZ_UPDATE_TIME TIMESTAMP not null,

constraint PK_LA_QUIZ primary key (QUZ_ID)

);

create table LA_QUIZ_RECORD (

RCRD_ID SERIAL not null,

RCRD_QUZ_ID int not null,

RCRD_USR_ID VARCHAR not null,

RCRD_ACTIVE BOOL not null,

RCRD_SUBJECT varchar not null,

RCRD_CHOICES varchar not null,

constraint PK_LA_QUIZ_RECORD primary key (RCRD_ID)

);

create table LA_RECORD (

CRD_ID SERIAL not null,

CRD_REQUEST varchar null,

CRD_RESPONSE varchar null,

CRD_TIME TIMESTAMP null,

constraint PK_LA_RECORD primary key (CRD_ID)

);

create table LA_RL_HISTORY (

HSTR_USR_ID varchar not null,

HSTR_RL_ID INT4 not null,

HSTR_UPDATE_TIME TIMESTAMP not null

);

create table LA_ROLE (

RL_ID SERIAL not null,

RL_NAME varchar not null,

RL_BU varchar not null,

RL_TITLE varchar null,

RL_GRADE varchar null,

RL_ACTIVE BOOL not null,

constraint PK_LA_ROLE primary key (RL_ID)

);

create table LA_USER (

USR_ID varchar not null,

USR_NAME varchar not null,

USR_BUDGET float not null,

USR_BALANCE float not null,

USR_BU varchar null,

USR_TITLE varchar null,

USR_GRADE varchar null,

USR_RL_ID int null,

USR_ACTIVE BOOL not null,

USR_SESSION TIMESTAMP not null default '0001-01-01 00:00:00',

constraint PK_LA_USER primary key (USR_ID)

);