AP_PARAM   
-
ID PK NUMBER 
NAME  String 
TYPE Null String 
CODE Null String 
VALUE Null String 
STATUS Null NUMBER 
DESCRIPTION Null String 
PARENT_CODE Null String 
   
   
BANNERS   
-
ID PK Number 
Name Null String 
Path_Image  String 
Post_Link  String 
Order_Banner  Number 
Description Null String  
Status Null Number 
Creat_Time  Null Date 
 Null  
   
CATEGORY   
-
ID PK NUMBER 
NAME Null String 
TYPE_CODE Null NUMBER 
STATUS Null NUMBER 
TYPE_FILE_1  String 
TYPE_FILE_2  String 
PATH_FILE_1   String 
PATH_FILE_2  String 
CREATED_DATE Null NUMBER 
UPDATED_DATE Null NUMBER 
TRANSCRIPT Null String 
PARENT_ID FK >- TOPICS.ID 
   
   
DETAILS_HISTORY   
-
ID PK NUMBER 
PARENT_ID NUMBER_FK
TYPE_TEST Null NUMBER 
START_TIME  DATE 
END_TIME  DATE 
   
   
EXAM_QUESTION   
-
ID PK NUMBER 
PARENT_ID NUMBER_FK
SENTENCE_NO  String 
PART  String 
PATH_FILE_1  String 
TYPE_FILE_1  String 
PATH_FILE_2 Null String 
TYPE_FILE_2 Null String 
PATH_FILE_3 Null String 
TYPE_FILE_3 Null String 
   
   
HISTORY   
-
ID PK NUMBER(8) 
USER_ID NUMBER FK >- USERS.USER_ID
TOPIC_ID NUMBER FK >- TOPICS.ID
CREATED_DATE  DATE 
STATUS Null NUMBER(1) 
TEST_ID NUMBER FK >- TEST.ID
TOTAL_SCOPE Null NUMBER(28) 
   
   
OBJECTS   
-
ID PK NUMBER(8) 
TITLE  String 
TYPE Null String 
STATUS Null NUMBER(1) 
NAVLINK  String 
IOON Null String 
   
   
QUESTION_ANSWER_LISTENING   
-
ID PK NUMBER(8) 
NAME  String 
ANSWER  String 
PARENT_ID NUMBER FK >- CATEGORY.ID
DESCRIPTION Null String 
STATUS Null NUMBER(1) 
START_TIME Null String 
ANSWER_TO_CHOOSE  String 
TYPE_FILE_1  String 
TYPE_FILE_2 Null String 
PATH_FILE_1  String 
PATH_FILE_2 Null String 
TRANSCRIPT Null String 
   
   
QUESTION_ANSWER_READING   
-
ID PK NUMBER(8) 
NAME Null String 
ANSWER  String 
PARENT_ID NUMBER FK >- CATEGORY.ID
DESCRIPTION Null String 
STATUS Null NUMBER(1) 
ANSWER_TO_CHOOSE  String 
   
   
ROLES   
-
ID PK NUMBER(8) 
NAME  VARCHAR2(100BYTE)
CODE Null VARCHAR2(100BYTE) 
DESCRIPTION Null VARCHAR2(500BYTE) 
STATUS Null NUMBER(1) 
   
   
   
   
ROLE_OBJECTS
-
ID PK NUMBER 
ROLE_ID NUMBER FK >- ROLES.ID
OBJECT_ID NUMBER FK >- OBJECTS.ID
STATUS Null NUMBER 
   
TEST   
-
ID PK NUMBER(10) 
NAME Null String 
STATUS Null NUMBER(1) 
CREATE_TIME Null DATE 
UPDATED_TIME Null DATE 
PATH_FILE_AUDIO  String 
   
TEST_QUEST   
-
ID PK NUMBER(10) 
PARENT_ID NUMBER_FK
NAME  String 
ANSWER  String 
ANSWER_TO_CHOOSE  String 
DESCRIPTION Null String 
NUMBER_SENTENCE Null NUMBER 
   
   
   
TOPICS   
-
ID PK NUMBER(10) 
NAME  String 
STATUS Null NUMBER 
LEVEL_CODE  NUMBER(20) 
CREATED_TIME Null DATE 
CODE Null String 
PART_TOPIC_CODE Null String 
TYPE_TOPIC_CODE  String
   
USERS   
-
USER_ID PK NUMBER(6) 
USER_NAME  String 
PASSWORD  String 
STATUS Null NUMBER(1) 
USER_SHOW_NAME  String 
CREATE_DATE Null DATE 
UPDATE_DATE Null DATE 
NEAREST_LOGIN_DATE Null DATE 
BIRTHDAY Null DATE 
LEVEL_CODE Null NUMBER(6) 
PAID_A_FEE  NUMBER(38) 
PAYMENT_DATE  DATE 
TIME_EXPIRED  DATE 
TARGET Null NUMBER(38) 
USER_AVATAR Null String 
CODE_USER Null String 
PHONE  String 
CURRENT_SCORE Null NUMBER(38) 
PAYMENT_STATUS  NUMBER(38) 
VERIFIED Null NUMBER(1) 
   
   
USER_ROLES   
-
ID PK NUMBER 
USER_ID NUMBER FK >- USERS.USER_ID
ROLE_ID NUMBER FK >- ROLES.ID
STATUS Null NUMBER 
DESCRIPTION Null String