|
| 1 | +/*==============================================================*/ |
| 2 | +/* DBMS name: PostgreSQL 9.x */ |
| 3 | +/* Created on: 12/29/2017 9:18:09 AM */ |
| 4 | +/*==============================================================*/ |
| 5 | + |
| 6 | + |
| 7 | +drop table LA_COURSE; |
| 8 | + |
| 9 | +drop table LA_CRS_HISTORY; |
| 10 | + |
| 11 | +drop table LA_GOLDEN_SAMPLE; |
| 12 | + |
| 13 | +drop table LA_RL_HISTORY; |
| 14 | + |
| 15 | +drop table LA_ROLE; |
| 16 | + |
| 17 | +drop table LA_USER; |
| 18 | + |
| 19 | +/*==============================================================*/ |
| 20 | +/* Table: LA_COURSE */ |
| 21 | +/*==============================================================*/ |
| 22 | +create table LA_COURSE ( |
| 23 | + CRS_ID SERIAL not null, |
| 24 | + CRS_NAME varchar not null, |
| 25 | + CRS_PRICE float not null, |
| 26 | + CRS_STARTDATE DATE null, |
| 27 | + CRS_ENDDATE DATE null, |
| 28 | + CRS_ACTIVE BOOL not null, |
| 29 | + constraint PK_LA_COURSE primary key (CRS_ID) |
| 30 | +); |
| 31 | + |
| 32 | +/*==============================================================*/ |
| 33 | +/* Table: LA_CRS_HISTORY */ |
| 34 | +/*==============================================================*/ |
| 35 | +create table LA_CRS_HISTORY ( |
| 36 | + HSTR_USR_ID varchar not null, |
| 37 | + HSTR_CRS_ID int not null |
| 38 | +); |
| 39 | + |
| 40 | +/*==============================================================*/ |
| 41 | +/* Table: LA_GOLDEN_SAMPLE */ |
| 42 | +/*==============================================================*/ |
| 43 | +create table LA_GOLDEN_SAMPLE ( |
| 44 | + SMPL_NAME varchar not null, |
| 45 | + SMPL_ROLE varchar not null, |
| 46 | + SMPL_RL_NAME varchar not null, |
| 47 | + SMPL_MANDATORY varchar not null, |
| 48 | + SMPL_OPTIONAL varchar not null, |
| 49 | + SMPL_UPDATE_TIME TIMESTAMP not null, |
| 50 | + SMPL_ACTIVE BOOL not null |
| 51 | +); |
| 52 | + |
| 53 | +/*==============================================================*/ |
| 54 | +/* Table: LA_RL_HISTORY */ |
| 55 | +/*==============================================================*/ |
| 56 | +create table LA_RL_HISTORY ( |
| 57 | + HSTR_USR_ID varchar not null, |
| 58 | + HSTR_RL_NAME varchar not null, |
| 59 | + HSTR_RL_HISTORY varchar not null, |
| 60 | + HSTR_UPDATE_TIME TIMESTAMP not null |
| 61 | +); |
| 62 | + |
| 63 | +/*==============================================================*/ |
| 64 | +/* Table: LA_ROLE */ |
| 65 | +/*==============================================================*/ |
| 66 | +create table LA_ROLE ( |
| 67 | + RL_NAME varchar not null, |
| 68 | + RL_BU varchar null, |
| 69 | + RL_TITLE varchar null, |
| 70 | + RL_GRADE varchar null, |
| 71 | + RL_ACTIVE BOOL not null, |
| 72 | + constraint PK_LA_ROLE primary key (RL_NAME) |
| 73 | +); |
| 74 | + |
| 75 | +/*==============================================================*/ |
| 76 | +/* Table: LA_USER */ |
| 77 | +/*==============================================================*/ |
| 78 | +create table LA_USER ( |
| 79 | + USR_ID varchar not null, |
| 80 | + USR_NAME varchar not null, |
| 81 | + USR_BUDGET float not null, |
| 82 | + USR_BALANCE float not null, |
| 83 | + USR_BU varchar null, |
| 84 | + USR_TITLE varchar null, |
| 85 | + USR_GRADE varchar null, |
| 86 | + USR_RL_NAME varchar null, |
| 87 | + USR_ACTIVE BOOL not null, |
| 88 | + constraint PK_LA_USER primary key (USR_ID) |
| 89 | +); |
| 90 | + |
0 commit comments