RSCP
Tables (5)
T_BASKET
- MEMBERUID — NUMBER(11) — NOT NULL — 소비처
- PRD_CODE — VARCHAR2(10) — NOT NULL
- PRD_NAME — VARCHAR2(30) — NOT NULL
- PRD_MONEY — VARCHAR2(11) — NOT NULL
- PRD_COUNT — VARCHAR2(11) — NOT NULL
- GET_NAME — VARCHAR2(30) — NOT NULL
- GET_ZIP — CHAR(5) — NOT NULL
- GET_ADDR — VARCHAR2(200) — NOT NULL
- GET_TEL — VARCHAR2(13) — NOT NULL
- GET_HP — VARCHAR2(13) — NOT NULL
- R_DATE — TIMESTAMP — NOT NULL
T_BBS_DATA
- IDX — NUMBER(11) — Primary key — NOT NULL — 게시글
- GID — NUMBER(11,2)
- BBS — NUMBER(11)
- BBSID — VARCHAR2(30)
- DEPTH — NUMBER(4)
- NOTICE — NUMBER(4)
- NAME — VARCHAR2(30)
- NIC — VARCHAR2(50)
- MBRUID — NUMBER(11)
- ID — VARCHAR2(30)
- SUBJECT — VARCHAR2(200)
- CONTENT — VARCHAR2(500)
- HTML — VARCHAR2(4)
- HIT — NUMBER(11)
- FILE_NAME — VARCHAR2(250)
- FILE_FOLDER — VARCHAR2(30)
- FILE_THUMBNAME — VARCHAR2(100)
- D_REGIS — VARCHAR2(14)
- UP_DATE — VARCHAR2(14)
T_BBS_LIST
- IDX — NUMBER(11) — 게시판고유번호;
- GID — NUMBER(11)
- ID — VARCHAR2(30)
- NAME — VARCHAR2(200)
- NUM_R — NUMBER(11)
- D_LAST — VARCHAR2(14)
- D_REGIS — VARCHAR2(14)
- ADDINFO — VARCHAR2(100)
T_MEMBER
- MEMBERUID — NUMBER(11) — Primary key — NOT NULL
- ID — VARCHAR2(50) — NOT NULL
- PW — VARCHAR2(50) — NOT NULL
- GROUBID — NUMBER(2) — NOT NULL
- USING_YN — CHAR(1) — NOT NULL
- B_NAME — VARCHAR2(30)
- B_CEO — VARCHAR2(12)
- B_LICENSE — VARCHAR2(10)
- B_CATEGORY — VARCHAR2(30)
- B_ITEM — VARCHAR2(30)
- B_ZIP — CHAR(5)
- B_ADDR1 — VARCHAR2(200)
- B_ADDR2 — VARCHAR2(100)
- B_TEL — VARCHAR2(13)
- B_EMAIL — VARCHAR2(50)
- B_IMG_NAME — VARCHAR2(250)
- B_IMG_FOLDER — VARCHAR2(30)
- B_IMG_THUMBNAME — VARCHAR2(100)
- NAME — VARCHAR2(30)
- BIRTH_Y — CHAR(4)
- BIRTH_M — CHAR(2)
- BIRTH_D — CHAR(2)
- SEX — NUMBER(1)
- TEL — VARCHAR2(13)
- ZIP — CHAR(5)
- ADDR1 — VARCHAR2(200)
- ADDR2 — VARCHAR2(100)
- EMAIL — VARCHAR2(50)
- D_REGIS — VARCHAR2(14)
T_ORDER_HEAD
- ORDER_NO — VARCHAR2(22) — Primary key — NOT NULL — 주문번호;
- MEMBERUID (MEMBERUID2) — NUMBER(11) — Foreign key → T_MEMBER.MEMBERUID — NOT NULL
- MEMBERUID — NUMBER(11) — NOT NULL
- ORDER_MONEY — VARCHAR2(11) — NOT NULL
- R_DATE — TIMESTAMP — NOT NULL
- OUT_END_YN — CHAR(2) — NOT NULL
- CONF_END_YN — CHAR(2) — NOT NULL