togym
Tables (10)
BANK_TB
- BK_NO — NUMBER — Primary key — NOT NULL
- BK_ACCOUNT — NVARCHAR2(20) — NOT NULL
- BK_PWD — NVARCHAR2(20) — NOT NULL
- BK_NAME — NVARCHAR2(20) — NOT NULL
- BK_CHECK — NUMBER
BUY_TB
- B_CODE — NVARCHAR2(20) — Primary key — NOT NULL
- B_CATE — NVARCHAR2(10) — NOT NULL
- B_SUBCATE — NVARCHAR2(10) — NOT NULL
- B_TITLE — NVARCHAR2(50) — NOT NULL
- B_TERM — NVARCHAR2(10) — NOT NULL
- B_PRICE — NUMBER — NOT NULL
CART_TB
- C_CODE — NVARCHAR2(20) — Primary key — NOT NULL
- M_ID — NVARCHAR2(20) — NOT NULL
- B_CODE — NVARCHAR2(20) — NOT NULL
MEMBER_TB
- M_ID — NVARCHAR2(20) — Primary key — NOT NULL
- M_PW — NVARCHAR2(100) — NOT NULL
- M_NAME — NVARCHAR2(10) — NOT NULL
- M_EMAIL — NVARCHAR2(50) — NOT NULL
- M_PHONE — NVARCHAR2(11) — NOT NULL
- M_BIRTH — NVARCHAR2(6) — NOT NULL
- M_JOINDATE — DATE — NOT NULL
- M_POINT — NUMBER — NOT NULL
PAY_TB
- P_NO — NUMBER — Primary key — NOT NULL
- C_CODE — NVARCHAR2(20) — NOT NULL
- P_TOTAL — NUMBER — NOT NULL
- P_DATE — DATE
- P_PAYMENT — NVARCHAR2(20)
REVIEW_TB
- R_NO — NUMBER — Primary key — NOT NULL
- R_CATE — NVARCHAR2(10) — NOT NULL
- R_TITLE — NVARCHAR2(20) — NOT NULL
- R_CONTENTS — NCLOB — NOT NULL
- M_ID — NVARCHAR2(20) — NOT NULL
- R_DATE — DATE — NOT NULL
- R_SCORE — NUMBER — NOT NULL
RIMG_TB
- RIMG_NO — NUMBER — Primary key — NOT NULL
- R_NO — NUMBER — NOT NULL
- RIMG_ORI — NVARCHAR2(500) — NOT NULL
- RIMG_SYS — NVARCHAR2(50) — NOT NULL
SIMG_TB
- SIMG_NO — NUMBER — Primary key — NOT NULL
- S_CODE — NVARCHAR2(20) — NOT NULL
- SIMG_ORI — NVARCHAR2(500) — NOT NULL
- SIMG_SYS — NVARCHAR2(50) — NOT NULL
SPOT_TB
- S_CODE — NVARCHAR2(20) — Primary key — NOT NULL
- S_NAME — NVARCHAR2(20) — NOT NULL
- S_PHONE — NVARCHAR2(11) — NOT NULL
- S_ADDR — NVARCHAR2(50) — NOT NULL
- S_CONTENTS — NCLOB
TICKET_TB
- T_NO — NUMBER — Primary key — NOT NULL
- P_NO — NUMBER — NOT NULL
- T_USE — NCHAR(1) — NOT NULL