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