O!ASIS
Tables (11)
ALARM
- ARLAM — NUMBER — NOT NULL
- A_STORE — NUMBER — NOT NULL
- AB_IDX — VARCHAR2(13) — NOT NULL
BOOKMARK
- B_STORE — NUMBER — NOT NULL
- BS_NAME — VARCHAR2(100) — NOT NULL
- BB_IDX — VARCHAR2(13) — NOT NULL
B_MEMBER
- B_PHONE — VARCHAR2(13)
- B_PASSWORD — VARCHAR2(30) — NOT NULL
- B_NAME — VARCHAR2(30) — NOT NULL
- B_NICKNAME — VARCHAR2(30) — NOT NULL
- B_DATE — DATE — NOT NULL
- STAMP — NUMBER
CART
- CP_NAME — VARCHAR2(100)
- C_PRICE — NUMBER — NOT NULL
- C_OP — VARCHAR2(3000) — NOT NULL
- C_IDX — NUMBER
- C_STORE — NUMBER — NOT NULL
- CB_IDX — VARCHAR2(13) — NOT NULL
- CP_IDX — NUMBER — NOT NULL
- C_COUNT — NUMBER — NOT NULL
COUPON
- CU_IDX — NUMBER
- COUPON — VARCHAR2(100) — NOT NULL
- CU_PRICE — VARCHAR2(10) — NOT NULL
- CUB_IDX — VARCHAR2(13) — NOT NULL
- CU_LIMIT — DATE — NOT NULL
NOTICE
- N_IDX — NUMBER
- N_TITLE — VARCHAR2(30) — NOT NULL
- N_CONTENT — VARCHAR2(600) — NOT NULL
- N_DATE — DATE — NOT NULL
- N_TYPE — VARCHAR2(1) — NOT NULL
ORDERS
- O_STORE — NUMBER — NOT NULL
- OS_NAME — VARCHAR2(100) — NOT NULL
- O_COUNT — NUMBER — NOT NULL
- O_SUM — NUMBER — NOT NULL
- O_IDX — NUMBER
- O_STATUS — NUMBER — NOT NULL
- O_LIST — VARCHAR2(3000) — NOT NULL
- O_DATE — DATE — NOT NULL
- O_PICK — NUMBER — NOT NULL
- O_TIME — NUMBER — NOT NULL
- OB_IDX — VARCHAR2(13) — NOT NULL
PRODUCT
- P_IDX — NUMBER
- P_NAME — VARCHAR2(100) — NOT NULL
- P_IMG — VARCHAR2(80) — NOT NULL
- P_CONTENT — VARCHAR2(1000) — NOT NULL
- P_PRICE — NUMBER — NOT NULL
SALES
- S_IDX — NUMBER
- S_DATE — DATE — NOT NULL
- S_SUM — NUMBER — NOT NULL
- SO_SOUNT — NUMBER — NOT NULL
STATUS
- SS_IDX — NUMBER(10) — NOT NULL
- SP_IDX — NUMBER — NOT NULL
- S_SO — VARCHAR2(1) — NOT NULL
S_MEMBER
- STORE — NUMBER
- S_PASSWORD — VARCHAR2(30) — NOT NULL
- S_NAME — VARCHAR2(300) — NOT NULL
- S_MANAGER — VARCHAR2(300) — NOT NULL
- ADDRESS1 — VARCHAR2(300)
- ADDRESS2 — VARCHAR2(300)
- POSTCODE — VARCHAR2(7) — NOT NULL
- S_PHONE — NUMBER — NOT NULL
- S_STATUS — NUMBER — NOT NULL
- DEL_GB — VARCHAR2(1) — NOT NULL