sinau

Tables (25)

ACCOUNT

  • ACC_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • ACC_BANK — NVARCHAR2(20) — NOT NULL
  • ACC_NUM — NUMBER — NOT NULL

CATEGORY_SUB

  • CTS_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • CTS_NAME — NVARCHAR2(20) — NOT NULL

CHAT

  • CH_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • CH_EMAIL — NVARCHAR2(20) — NOT NULL
  • CH_ORI — NVARCHAR2(20) — NOT NULL
  • CH_CONTENT — NVARCHAR2(20) — NOT NULL

COUPON

  • CP_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • CP_TITLE — NVARCHAR2(50) — NOT NULL
  • CP_DISCOUNT — NUMBER — NOT NULL
  • CP_DATE — DATE — NOT NULL
  • CP_CONTENT — NVARCHAR2(100) — NOT NULL

COUPONLIST

  • CPL_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • CPL_CP_CODE — NVARCHAR2(20) — Foreign key → COUPON.CP_CODE — NOT NULL
  • CPL_M_EMAIL — NVARCHAR2(20) — NOT NULL

FEEDBACK

  • FB_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • FB_CONTENT — NVARCHAR2(200) — NOT NULL
  • FB_DATE — DATE — NOT NULL
  • FB_REPLY — NVARCHAR2(200)
  • FB_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • FB_VF_CODE — NVARCHAR2(20) — NOT NULL

FILES

  • F_CODE — NVARCHAR2(50) — Primary key — NOT NULL
  • F_ORINAME — NVARCHAR2(50) — NOT NULL
  • F_SYSNAME — NVARCHAR2(50) — NOT NULL
  • F_PCODE — NVARCHAR2(20) — NOT NULL
  • F_CTS_CODE — NVARCHAR2(20) — NOT NULL

LIKES

  • L_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • L_COUNT — NUMBER — NOT NULL
  • L_STATE — NUMBER(1,0) — NOT NULL
  • L_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • L_PCODE — NVARCHAR2(20) — NOT NULL
  • L_CTS_CODE — NVARCHAR2(20) — NOT NULL

MEMBER

  • M_EMAIL — NVARCHAR2(50) — Primary key — NOT NULL
  • M_NAME — NVARCHAR2(20) — NOT NULL
  • M_PWD — NVARCHAR2(80) — NOT NULL
  • M_PHONE — NVARCHAR2(13) — NOT NULL
  • M_BIRTH — DATE
  • M_LICENSE — NUMBER
  • M_GROUP — NVARCHAR2(20) — NOT NULL
  • M_STATE — NUMBER — NOT NULL
  • M_ACC_CODE — NVARCHAR2(20)

MEMBERIMG

  • MIMG_CODE — NVARCHAR2(50) — Primary key — NOT NULL
  • MIMG_ORINAME — NVARCHAR2(50) — NOT NULL
  • MIMG_SYSNAME — NVARCHAR2(50) — NOT NULL
  • MIMG_M_EMAIL — NVARCHAR2(50) — NOT NULL

MYCLASS

  • MCL_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • MCL_STATE — NUMBER — NOT NULL
  • MCL_CLASSCODE — NVARCHAR2(20) — NOT NULL
  • MCL_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • MCL_ORD_CODE — NVARCHAR2(20) — NOT NULL
  • MCL_SC_CODE — VARCHAR2(20 BYTE)

OFFCLASS

  • OFC_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • OFC_TITLE — NVARCHAR2(50) — NOT NULL
  • OFC_CONTENT — NVARCHAR2(200) — NOT NULL
  • OFC_TEACHER — NVARCHAR2(20) — NOT NULL
  • OFC_SALE — NUMBER — NOT NULL
  • OFC_UPDATE — DATE — NOT NULL
  • OFC_VIEW — NUMBER — NOT NULL
  • OFC_STNUM — NUMBER — NOT NULL
  • OFC_STATE — NUMBER(1,0) — NOT NULL
  • OFC_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • OFC_CTS_CODE — NVARCHAR2(20) — NOT NULL
  • OFC_LEVEL — NVARCHAR2(20)

ONLINECLASS

  • ONC_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • ONC_TITLE — NVARCHAR2(50) — NOT NULL
  • ONC_CONTENT — NVARCHAR2(200) — NOT NULL
  • ONC_TEACHER — NVARCHAR2(20) — NOT NULL
  • ONC_SALE — NUMBER — NOT NULL
  • ONC_UPDATE — DATE — NOT NULL
  • ONC_LEVEL — NVARCHAR2(20) — NOT NULL
  • ONC_VIEW — NUMBER — NOT NULL
  • ONC_STNUM — NUMBER — NOT NULL
  • ONC_STATE — NUMBER(1,0) — NOT NULL
  • ONC_SDATE — DATE — NOT NULL
  • ONC_EDATE — DATE — NOT NULL
  • ONC_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • ONC_CTS_CODE — NVARCHAR2(20) — NOT NULL

ORDERS

  • ORD_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • ORD_NAME — NVARCHAR2(20) — NOT NULL
  • ORD_ADDR — NVARCHAR2(100) — NOT NULL
  • ORD_PHONE — NVARCHAR2(13) — NOT NULL
  • ORD_MEMO — NVARCHAR2(50)
  • ORD_PRICE — NUMBER — NOT NULL
  • ORD_DIPOSIT — NVARCHAR2(20) — NOT NULL
  • ORD_DATE — DATE — NOT NULL
  • ORD_STATE — NUMBER — NOT NULL
  • ORD_PCODE — NVARCHAR2(20) — NOT NULL
  • ORD_AMOUNT — NUMBER — NOT NULL
  • ORD_M_EMAIL — NVARCHAR2(20) — NOT NULL

PRODUCT

  • P_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • P_TITLE — NVARCHAR2(50) — NOT NULL
  • P_AMOUNT — NUMBER — NOT NULL
  • P_PRICE — NUMBER — NOT NULL
  • P_DATE — DATE — NOT NULL
  • P_SALAMOUNT — NUMBER — NOT NULL
  • P_DEALER — NVARCHAR2(20) — NOT NULL
  • P_VIEW — NUMBER — NOT NULL
  • P_M_EMAIL — NVARCHAR2(20) — NOT NULL
  • P_CTS_CODE — NVARCHAR2(20) — Foreign key → CATEGORY_SUB.CTS_CODE — NOT NULL
  • P_STATE — NUMBER

PRODUCTREVIEW

  • PRV_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • PRV_DATE — DATE — NOT NULL
  • PRV_CONTENT — NVARCHAR2(100) — NOT NULL
  • PRV_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • PRV_P_CODE — NVARCHAR2(20) — NOT NULL

QUESTION

  • Q_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • Q_TITLE — NVARCHAR2(50) — NOT NULL
  • Q_CONTENT — NVARCHAR2(250) — NOT NULL
  • Q_DATE — DATE — NOT NULL
  • Q_ANFIELD — NVARCHAR2(100)
  • Q_ANDATE — DATE
  • Q_CTS_CODE — NVARCHAR2(20) — Foreign key → CATEGORY_SUB.CTS_CODE — NOT NULL
  • Q_M_EMAIL — NVARCHAR2(20) — NOT NULL

REFUND

  • REF_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • REF_DATE — DATE — NOT NULL
  • REF_BANKNUM — NUMBER — NOT NULL
  • REF_BANK — NVARCHAR2(20) — NOT NULL
  • REF_BANKNAME — NVARCHAR2(20) — NOT NULL
  • REF_REASON — NVARCHAR2(50) — NOT NULL
  • REF_STATE — NUMBER — NOT NULL
  • REF_ORD_CODE — NVARCHAR2(20) — NOT NULL

SCHEDULE

  • SC_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • SC_TIME — DATE — NOT NULL
  • SC_PLACE — NVARCHAR2(50) — NOT NULL
  • SC_SCL_CODE — NVARCHAR2(20) — NOT NULL

SCHEDULELIST

  • SCL_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • SCL_OFC_CODE — NVARCHAR2(20) — NOT NULL

SHOPPINGLIST

  • SL_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • SL_PCODE — NVARCHAR2(20) — NOT NULL
  • SL_PRICE — NUMBER — NOT NULL
  • SL_STATE — NUMBER — NOT NULL
  • SL_AMOUNT — NUMBER — NOT NULL
  • SL_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • SL_ORD_CODE — NVARCHAR2(20) — NOT NULL

VIDEO

  • V_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • V_ONC_CODE — NVARCHAR2(20) — NOT NULL

VIDEOFILE

  • VF_CODE — NVARCHAR2(50) — Primary key — NOT NULL
  • V_TITLE — NVARCHAR2(50) — NOT NULL
  • V_CONTENT — NVARCHAR2(100) — NOT NULL
  • VF_ORINAME — NVARCHAR2(50) — NOT NULL
  • VF_SYSNAME — NVARCHAR2(50) — NOT NULL
  • VF_V_CODE — NVARCHAR2(20) — NOT NULL

WARNING

  • W_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • W_CONTENTNUM — NUMBER — NOT NULL
  • W_CONTENT — NVARCHAR2(255)
  • W_STATE — NUMBER — NOT NULL
  • W_M_EMAIL — NVARCHAR2(20) — Foreign key → MEMBER.M_EMAIL — NOT NULL
  • W_PRV_CODE — NVARCHAR2(20) — NOT NULL
  • W_UPDATE — DATE — NOT NULL

YOUTUBE_CLASS

  • Y_CODE — NVARCHAR2(20) — Primary key — NOT NULL
  • Y_TITLE — NVARCHAR2(50) — NOT NULL
  • Y_SUBTITLE — NVARCHAR2(20) — NOT NULL
  • Y_CONTENT — NVARCHAR2(200) — NOT NULL
  • Y_PROFILE — NVARCHAR2(200) — NOT NULL
  • Y_URL — NVARCHAR2(100) — NOT NULL
  • Y_USERURL — NVARCHAR2(100) — NOT NULL
  • Y_UPDATE — DATE — NOT NULL
  • Y_VIEW — NUMBER — NOT NULL
  • Y_VIEDOSOURE — NVARCHAR2(250) — NOT NULL
  • Y_CTS_CODE — NVARCHAR2(20) — NOT NULL