꼬부기소방대
테이블 (12)
BASKET
- M_INDEX — NUMBER(6)
- P_INDEX — NUMBER(6)
- B_STOCK — NUMBER(2)
DESSERT
- D_INDEX — NUMBER(6) — 기본 키
- D_NAME — VARCHAR2(255) — NOT NULL
- D_TEXT — CLOB
- D_IMAGE — CLOB
- D_VIEW — NUMBER(6)
- D_OPEN — NUMBER(1,0)
DESSERT_TAG
- D_INDEX — NUMBER(6)
- T_INDEX — NUMBER(6)
FREE_BOARD
- F_index — NUMBER(6) — 기본 키
- M_ID — VARCHAR2(20)
- F_SUBJECT — VARCHAR2(255)
- F_TEXT — CLOB
- F_IMAGE — CLOB
- F_CRE_DATE — DATE
- F_NOTICE — NUMBER(1,0)
MEMBER
- M_INDEX — NUMBER(6) — 기본 키
- M_ID — VARCHAR2(20) — NOT NULL
- M_PASSWORD — VARCHAR2(20) — NOT NULL
- M_NAME — VARCHAR2(100) — NOT NULL
- M_TEL — VARCHAR2(100) — NOT NULL
- M_EMAIL — VARCHAR2(100) — NOT NULL
- M_ADDRESS — VARCHAR2(100) — NOT NULL
- M_ADDRESS_SEC — VARCHAR2(100) — NOT NULL
- M_BIRTH — DATE — NOT NULL
- M_SIGN_TIME — DATE
- M_POINT — NUMBER(9)
- M_NOTE — VARCHAR2(4000)
MEMBER_ORDER
- M_INDEX — NUMBER(6)
- O_INDEX — NUMBER(6)
PRODUCT
- P_INDEX — NUMBER(6) — 기본 키
- P_NAME — VARCHAR2(100) — NOT NULL
- P_PRICE — NUMBER(6) — NOT NULL
- P_STOCK — NUMBER(6)
- P_INTRO — CLOB
- P_OPEN — NUMBER(1,0)
- P_IMAGE — CLOB
PRODUCT_TAG
- P_INDEX — NUMBER(6)
- T_INDEX — NUMBER(6)
REPLY
- R_INDEX — NUMBER(6) — 기본 키
- M_ID — VARCHAR2(20)
- R_TEXT — VARCHAR2(4000)
- F_INDEX — NUMBER(6)
- R_CRE_DATE — DATE
STATUS
- STA_INDEX — NUMBER(2)
- STA_STATUS — VARCHAR2(255) — NOT NULL
- STA_NOTICE — VARCHAR2(255) — NOT NULL
S_ORDER
- O_INDEX — NUMBER(6) — 기본 키
- STA_STATUS — VARCHAR2(20)
- O_TIME — DATE
- M_ADDRESS — VARCHAR2(100)
- M_ADDRESS_SEC — VARCHAR2(100)
- M_TEL — VARCHAR2(100)
TAG
- T_INDEX — NUMBER(6) — 기본 키
- T_NAME — VARCHAR2(20)NOT — NOT NULL