마지막 SEMI
테이블 (12)
CART
- CART_NO — NUMBER — 기본 키 — NOT NULL
- CART_COUNT — NUMBER — NOT NULL
- PROD_CODE (PROD_CODE2) — NUMBER — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
LEAVE_PERSON
- LEAVE_PER_NO — NUMBER — 기본 키 — NOT NULL
- ID — VARCHAR2(20 BYTE) — NOT NULL
- EMAIL — VARCHAR2(20 BYTE)
- JOINED_AT — DATE
- LEAVE_AT — DATE
PERSON
- PER_NO — NUMBER — 기본 키 — NOT NULL
- PW — VARCHAR2(20 BYTE) — NOT NULL
- PHONENO — NUMBER — NOT NULL
- POST_ADDRESS — VARCHAR2(5 BYTE)
- ROAD_ADDRESS — VARCHAR2(100 BYTE)
- JIBUN_ADDRESS — VARCHAR2(100 BYTE)
- DETAIL_ADDRESS — VARCHAR2(100 BYTE) — NOT NULL
- EMAIL — VARCHAR2(20 BYTE) — NOT NULL
- GENDER — VARCHAR2(10 BYTE) — NOT NULL
- NAME — VARCHAR2(20 BYTE) — NOT NULL
- AGGRECODE — NUMBER
- JOINED_AT — DATE
- ID — VARCHAR2(20 BYTE)
PIMG
- PIMG_NO — NUMBER — 기본 키 — NOT NULL
- PIMG_PATH — VARCHAR2(100 BYTE) — NOT NULL
- PIMG_FILE — VARCHAR2(50 BYTE) — NOT NULL
- PROD_CODE — NUMBER — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
PRODUCT
- PROD_CODE — NUMBER — 기본 키 — NOT NULL
- PROD_NAME — VARCHAR2(100 BYTE) — NOT NULL
- PROD_PATH — VARCHAR2(100 BYTE) — NOT NULL
- PROD_IMG_NAME — VARCHAR2(100 BYTE) — NOT NULL
- PROD_ORIGIN_PRICE — NUMBER
- PROD_STOCK — NUMBER
QNA
- QNA_NO — NUMBER — 기본 키 — NOT NULL
- TITLE — VARCHAR2(100 BYTE) — NOT NULL
- CONTENT — CLOB
- WRITE_AT — TIMESTAMP
- QNA_REPLY — VARCHAR2(1000 BYTE)
- PER_NO — NUMBER — 외래 키 → PERSON.PER_NO — NOT NULL
RECIPE
- RECIPE_NO — NUMBER — 기본 키 — NOT NULL
- TITLE — VARCHAR2(100 BYTE) — NOT NULL
- TOOL — VARCHAR2(1000 BYTE)
- CONTENT1 — VARCHAR2(200 BYTE)
- CONTENT2 — CLOB — NOT NULL
- WRITE_AT — TIMESTAMP
- MODIFIED_AT — TIMESTAMP
- PER_NO — NUMBER — 외래 키 → PERSON.PER_NO — NOT NULL
RECIPE_REPLY
- REPLY_NO — NUMBER — 기본 키 — NOT NULL
- CONTENT — VARCHAR2(1000 BYTE)
- GROUP_ORDER — NUMBER
- GROUP_NO — NUMBER — NOT NULL
- DEPTH — NUMBER
- WRITE_AT — DATE
- RE_WRITE_AT — DATE
- PER_NO — NUMBER — 외래 키 → PERSON.PER_NO — NOT NULL
- RECIPE_NO — NUMBER — 외래 키 → RECIPE.RECIPE_NO — NOT NULL
RECOMMAND
- RECOMMAND_NO — NUMBER — 기본 키 — NOT NULL
- PER_NO — NUMBER — 외래 키 → PERSON.PER_NO — NOT NULL
- RECIPE_NO — NUMBER — 외래 키 → RECIPE.RECIPE_NO — NOT NULL
RIMG
- RIMG_NO — NUMBER — 기본 키 — NOT NULL
- RIMG_PATH — VARCHAR2(100 BYTE) — NOT NULL
- RIMG_ORIGIN_NAME — VARCHAR2(300 BYTE) — NOT NULL
- RIMG_FILE_NAME — VARCHAR2(50 BYTE) — NOT NULL
- RECIPE_NO (RECIPE_NO2) — NUMBER — 외래 키 → RECIPE.RECIPE_NO — NOT NULL
SALE
- SALE_NO — NUMBER — 기본 키 — NOT NULL
- PROD_CODE — NUMBER — 외래 키 → PRODUCT.PROD_CODE — NOT NULL
- SALE_TITLE — VARCHAR2(100 BYTE)
- SALE_CONTENT — VARCHAR2(100 BYTE)
- SALE_PRICE — NUMBER
- PROD_PATH — VARCHAR2(100 BYTE) — NOT NULL
- PROD_IMG_NAME — VARCHAR2(100 BYTE) — NOT NULL
SLEEP_PERSON
- SLEEP_PER_NO — NUMBER — 기본 키 — NOT NULL
- ID — VARCHAR2(20 BYTE) — NOT NULL
- PW — VARCHAR2(20 BYTE) — NOT NULL
- PHONENO — NUMBER — NOT NULL
- POST_ADDRESS — VARCHAR2(5 BYTE)
- ROAD_ADDRESS — VARCHAR2(100 BYTE)
- JIBUN_ADDRESS — VARCHAR2(100 BYTE)
- DETAIL_ADDRESS — VARCHAR2(100 BYTE) — NOT NULL
- EMAIL — VARCHAR2(20 BYTE) — NOT NULL
- GENDER — NUMBER — NOT NULL
- NAME — VARCHAR2(20 BYTE) — NOT NULL
- AGGRECODE — NUMBER
- JOINED_AT — DATE
- SLEPT_AT — DATE