Oracle Apex
Tables (39)
APPBASE
- ID — NUMBER — Primary key — NOT NULL
APPBASE_ERR$
- ORA_ERR_NUMBER$ — NUMBER
- ORA_ERR_MESG$ — VARCHAR2(2000)
- ORA_ERR_ROWID$ — UROWID
- ORA_ERR_OPTYP$ — VARCHAR2(2)
- ORA_ERR_TAG$ — VARCHAR2(2000)
- ID — VARCHAR2(4000)
APP_LOGINHISTORY
- ID — VARCHAR2(50) — Primary key — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- STATUS — VARCHAR2(10)
- LOGIN_DATETIME — TIMESTAMP
- LOGOUT_DATETIME — TIMESTAMP
- CREATED — TIMESTAMP
- MACHINE_ID — VARCHAR2(50)
APP_USER
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- PHONE — VARCHAR2(50)
- PHONE_ALL — VARCHAR2(20)
- PRIVATE_AGREE_YN — VARCHAR2(10)
- MACHINE_ID — VARCHAR2(50)
- NICKNAME — VARCHAR2(100)
- ROLE — NUMBER
- USER_GROUP — VARCHAR2(50)
- AVATAR_PART1 — NUMBER
- AVATAR_PART2 — NUMBER
- AVATAR_PART3 — NUMBER
- AVATAR_PART4 — NUMBER
- AVATAR_COLOR — VARCHAR2(50)
- EVENT_BOOTH — NUMBER
- EVENT_TREASURE — NUMBER
- EVENT_OX — NUMBER
- EVENT_GUESTBOOK — NUMBER
- ACTIVE — NUMBER
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- NO — NUMBER
- NAME — VARCHAR2(50)
- MOBILE_NO — VARCHAR2(50)
- COMPANY — VARCHAR2(50)
- JOB_TITLE — VARCHAR2(50)
APP_USER2
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID (ID2) — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- PHONE — VARCHAR2(50)
- PHONE_ALL — VARCHAR2(20)
- PRIVATE_AGREE_YN — VARCHAR2(10)
- MACHINE_ID — VARCHAR2(50)
- NICKNAME — VARCHAR2(100)
- ROLE — NUMBER
- USER_GROUP — VARCHAR2(50)
- AVATAR_PART1 — NUMBER
- AVATAR_PART2 — NUMBER
- AVATAR_PART3 — NUMBER
- AVATAR_PART4 — NUMBER
- AVATAR_COLOR — VARCHAR2(50)
- EVENT_BOOTH — NUMBER
- EVENT_TREASURE — NUMBER
- EVENT_OX — NUMBER
- EVENT_GUESTBOOK — NUMBER
- ACTIVE — NUMBER
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- NO — NUMBER
- NAME — VARCHAR2(50)
- MOBILE_NO — VARCHAR2(50)
- COMPANY — VARCHAR2(50)
- JOB_TITLE — VARCHAR2(50)
APP_USER_SESSION
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- SESSION_KEY — VARCHAR2(50) — NOT NULL
- CREATED — TIMESTAMP
- UPDATED — TIMESTAMP
ASSETIMAGE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- CMS_USER_ID — VARCHAR2(50) — Foreign key → CMS_USER.ID — NOT NULL
- IMAGE_TYPE — NUMBER
- TITLE — VARCHAR2(200)
- FILE_NAME — VARCHAR2(100)
- URL_IMAGE — VARCHAR2(300)
- WIDTHINPX — NUMBER
- HEIGHTINPX — NUMBER
- CREATED — TIMESTAMP
ASSETVOD
- ID — VARCHAR2(50) — Primary key — NOT NULL
- CMS_USER_ID — VARCHAR2(50) — Foreign key → CMS_USER.ID — NOT NULL
- VOD_TYPE — NUMBER
- TITLE — VARCHAR2(200)
- FILE_NAME — VARCHAR2(100)
- URL_VOD — VARCHAR2(300)
- DURATIONINMS — NUMBER
- WIDTHINPX — NUMBER
- HEIGHTINPX — NUMBER
- CREATED — TIMESTAMP
- ORIGIN_URL_VOD — VARCHAR2(3000)
CMS_USER
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- ACCOUNT — VARCHAR2(50)
- PWD — VARCHAR2(50)
- ROLE — VARCHAR2(50)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- UPLOAD_KEY — VARCHAR2(50)
CODE
- CODE — NUMBER — Primary key — NOT NULL
- PCODE — NUMBER
- CODETYPE — NUMBER — NOT NULL
- CNAME — VARCHAR2(100) — NOT NULL
- CNAME_ENG — VARCHAR2(100)
- CDATA — VARCHAR2(50)
- USAGEYN — VARCHAR2(2)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
CODETYPE
- CODETYPE — NUMBER — Foreign key → CODE.CODE — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- NAME_ENG — VARCHAR2(100)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
CONFERENCE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- NAME — VARCHAR2(50)
- TARGET_DATE — TIMESTAMP
- IMAGE_URL — VARCHAR2(300)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
CONFERENCE_URLS
- ID — VARCHAR2(100) — Primary key — NOT NULL
- CONFERENCE_ID — VARCHAR2(50) — Foreign key → CONFERENCE.ID — NOT NULL
- SEQ — NUMBER
- VOD_URL — VARCHAR2(200)
- THUMBNAIL_URL — VARCHAR2(200)
DATA_ACCESS_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- ZONE — VARCHAR2(50) — NOT NULL
- DATA_CODE — VARCHAR2(50) — NOT NULL
- NAME — VARCHAR2(100)
- URL — VARCHAR2(200)
- CREATED — TIMESTAMP
DEPT
- DEPTNO — NUMBER(2,0) — Primary key — NOT NULL
- DNAME — VARCHAR2(14)
- LOC — VARCHAR2(13)
DEVICE_NOTICE
- ID — VARCHAR2(50)
- PROJECT_ID — VARCHAR2(50) — NOT NULL
- DEVICE — VARCHAR2(10) — NOT NULL
- BUTTON_QUANTITY — NUMBER
- MESSAGE — VARCHAR2(100) — NOT NULL
- STARTDATE — TIMESTAMP
- ENDDATE — TIMESTAMP
- CREATED — TIMESTAMP
- UPDATED — TIMESTAMP
EMP
- EMPNO — NUMBER(4,0) — NOT NULL
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- MGR — NUMBER(4,0)
- HIREDATE — DATE
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- DEPTNO — NUMBER(2,0) — Foreign key → DEPT.DEPTNO — NOT NULL
EVENT_DATE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- TITLE — VARCHAR2(50)
- STARTDATE — TIMESTAMP
- SHOUR — VARCHAR2(10)
- SMINUTE — VARCHAR2(10)
- ENDDATE — TIMESTAMP
- EHOUR — VARCHAR2(10)
- EMINUTE — VARCHAR2(10)
- DESCRIPTION — VARCHAR2(500)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- MAX_PLAYER — NUMBER
- QUIZID — VARCHAR2(64)
- GUESTBOOK_DISPLAY_YN — VARCHAR2(1)
- GUESSWORD_DISPLAY_YN — VARCHAR2(1)
- LOGO_URL1 — VARCHAR2(511)
- LANGUAGE_TABLE_URL — VARCHAR2(511)
- LOGO_URL2 — VARCHAR2(511)
- GUESTBOOK_LIMIT — NUMBER
- NEXT_SCENE — VARCHAR2(50)
- ALERT_ID — VARCHAR2(500)
- PROJECT_INITIALS — VARCHAR2(2)
- DEFAULT_AVATAR_KEY — NUMBER
- QUIZ_CHANCE — NUMBER
- QUIZ_WAITING_TIME — NUMBER
- QUIZ_SOLVING_TIME — NUMBER
- QUIZ_ANSWER_CHECK_TIME — NUMBER
EVENT_JOIN_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- EVENT — VARCHAR2(50) — NOT NULL
- DATA — VARCHAR2(50) — NOT NULL
- CREATED — TIMESTAMP
GOVENT
- ID — NUMBER — Primary key — NOT NULL
GOVENT_ERR$
- ORA_ERR_NUMBER$ — NUMBER
- ORA_ERR_MESG$ — VARCHAR2(2000)
- ORA_ERR_ROWID$ — UROWID
- ORA_ERR_OPTYP$ — VARCHAR2(2)
- ORA_ERR_TAG$ — VARCHAR2(2000)
- ID — VARCHAR2(4000)
GUESTBOOK
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- USER_ID — VARCHAR2(50)
- CONTENTS — VARCHAR2(300)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
HTMLDB_PLAN_TABLE
- STATEMENT_ID — VARCHAR2(30)
- PLAN_ID — NUMBER
- TIMESTAMP — DATE
- REMARKS — VARCHAR2(4000)
- OPERATION — VARCHAR2(30)
- OPTIONS — VARCHAR2(255)
- OBJECT_NODE — VARCHAR2(128)
- OBJECT_OWNER — VARCHAR2(128)
- OBJECT_NAME — VARCHAR2(128)
- OBJECT_ALIAS — VARCHAR2(261)
- OBJECT_INSTANCE — NUMBER(*,0)
- OBJECT_TYPE — VARCHAR2(128)
- OPTIMIZER — VARCHAR2(255)
- SEARCH_COLUMNS — NUMBER
- ID — NUMBER(*,0)
- PARENT_ID — NUMBER(*,0)
- DEPTH — NUMBER(*,0)
- POSITION — NUMBER(*,0)
- COST — NUMBER(*,0)
- CARDINALITY — NUMBER(*,0)
- BYTES — NUMBER(*,0)
- OTHER_TAG — VARCHAR2(255)
- PARTITION_START — VARCHAR2(255)
- PARTITION_STOP — VARCHAR2(255)
- PARTITION_ID — NUMBER(*,0)
- OTHER — LONG
- DISTRIBUTION — VARCHAR2(30)
- CPU_COST — NUMBER(*,0)
- IO_COST — NUMBER(*,0)
- TEMP_SPACE — NUMBER(*,0)
- ACCESS_PREDICATES — VARCHAR2(4000)
- FILTER_PREDICATES — VARCHAR2(4000)
- PROJECTION — VARCHAR2(4000)
- TIME — NUMBER(*,0)
- QBLOCK_NAME — VARCHAR2(128)
INSURANCE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- TITLE — VARCHAR2(50)
- TYPE — VARCHAR2(50)
- URLS — VARCHAR2(500)
- DESCRIPTION — VARCHAR2(500)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- POSITION — NUMBER
INSURANCE_URLS
- ID — VARCHAR2(100) — NOT NULL
- INSURANCE_ID — VARCHAR2(50) — Foreign key → INSURANCE.ID — NOT NULL
- URL — VARCHAR2(200)
- SEQ — NUMBER
LIVE_DATE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- TITLE — VARCHAR2(50)
- STARTDATE — TIMESTAMP
- SHOUR — VARCHAR2(10)
- SMINUTE — VARCHAR2(10)
- ENDDATE — TIMESTAMP
- EHOUR — VARCHAR2(10)
- EMINUTE — VARCHAR2(10)
- DESCRIPTION — VARCHAR2(500)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
NPC
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- NAME — VARCHAR2(50)
- SCENE — NUMBER
- MODEL — NUMBER
- MOVERANGE — NUMBER
- POSITION_X — NUMBER
- POSITION_Y — NUMBER
- POSITION_Z — NUMBER
- ROTATION_X — NUMBER
- ROTATION_Y — NUMBER
- ROTATION_Z — NUMBER
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
NPC_DESCRIPT
- ID — VARCHAR2(50) — Primary key — NOT NULL
- NPC_ID — VARCHAR2(50) — Foreign key → NPC.ID — NOT NULL
- TITLE — VARCHAR2(300)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
NPC_SELECT
- ID — VARCHAR2(50) — Primary key — NOT NULL
- NPC_ID — VARCHAR2(50) — Foreign key → NPC.ID — NOT NULL
- TYPE — NUMBER
- DESCRIPT — VARCHAR2(100)
- PARAM — VARCHAR2(200)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
PROJECT
- ID — VARCHAR2(100) — Primary key — NOT NULL
- NAME — VARCHAR2(100)
- DESCRIPTION — VARCHAR2(100)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- CHNL_LMT_PCNT — NUMBER
- ROLE) — values(:new.id
QUIZ_ANSWER_STATUS
- ID — VARCHAR2(50) — NOT NULL
- QUIZ_MASTER_ID — VARCHAR2(50) — Foreign key → QUIZ_MASTER.ID — NOT NULL
- QUIZ_TABLE_ID — VARCHAR2(50) — Foreign key → QUIZ_TABLE.ID — NOT NULL
- USER_ID — VARCHAR2(50) — NOT NULL
- QUESTION — VARCHAR2(100)
- ANSWER — NUMBER
- ANSWER_STR — VARCHAR2(100)
- SEL_ANSWER — NUMBER
- SEL_ANSWER_STR — VARCHAR2(100)
- CREATED — TIMESTAMP
- SEQ — NUMBER
- BONUS_YN — VARCHAR2(10)
QUIZ_CHOICE_ITEM
- ID — VARCHAR2(50) — Primary key — NOT NULL
- QUIZ_TABLE_ID — VARCHAR2(50) — Foreign key → QUIZ_TABLE.ID — NOT NULL
- ITEM_NUM — NUMBER
- ITEM_STR — VARCHAR2(100)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
QUIZ_MASTER
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- TITLE — VARCHAR2(100)
- QUIZ_DATE — TIMESTAMP
- SIMPLE_DATE — VARCHAR2(20)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
QUIZ_START_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- QUIZ_MASTER_ID — VARCHAR2(50) — Foreign key → QUIZ_MASTER.ID — NOT NULL
- QUIZ_TABLE_ID — VARCHAR2(50) — Foreign key → QUIZ_TABLE.ID — NOT NULL
- CREATED — TIMESTAMP
QUIZ_TABLE
- ID — VARCHAR2(50) — Primary key — NOT NULL
- QUIZ_MASTER_ID — VARCHAR2(50) — Foreign key → QUIZ_MASTER.ID — NOT NULL
- SEQ — NUMBER
- QUESTION — VARCHAR2(500)
- TYPE — NUMBER
- ANSWER — VARCHAR2(10)
- CREATED — TIMESTAMP
- CREATED_BY — VARCHAR2(255)
- UPDATED — TIMESTAMP
- UPDATED_BY — VARCHAR2(255)
- EXPLAIN — VARCHAR2(500)
- BONUS_YN — VARCHAR2(10)
URLS
- ID — VARCHAR2(100) — Primary key — NOT NULL
- PARENT_ID — VARCHAR2(50)
- SEQ — NUMBER
- CODE — VARCHAR2(10)
- TYPE — VARCHAR2(50)
- URL1 — VARCHAR2(200)
- URL2 — VARCHAR2(200)
- PROJECT_ID — VARCHAR2(50 — Foreign key → PROJECT.ID — NOT NULL
- NAME — VARCHAR2(100)
VOD_RUNNING_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- ZONE — VARCHAR2(50) — NOT NULL
- VOD_CODE — VARCHAR2(50) — NOT NULL
- NAME — VARCHAR2(100)
- URL — VARCHAR2(200)
- RUNNING_TIME — VARCHAR2(20) — NOT NULL
- CREATED — TIMESTAMP
VOD_VIEW_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- ZONE — VARCHAR2(50) — NOT NULL
- VOD_CODE — VARCHAR2(50) — NOT NULL
- NAME — VARCHAR2(100)
- URL — VARCHAR2(200)
- CREATED — TIMESTAMP
ZONE_MOVE_LOG
- ID — VARCHAR2(50) — Primary key — NOT NULL
- PROJECT_ID — VARCHAR2(50) — Foreign key → PROJECT.ID — NOT NULL
- APP_USER_ID — VARCHAR2(50) — Foreign key → APP_USER.ID — NOT NULL
- ZONE — VARCHAR2(50) — NOT NULL
- CREATED — TIMESTAMP