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