이커머스
테이블 (23)
BRD_CNTNT
- CONTENT_ID — VARCHAR2 — 기본 키 — NOT NULL
- BOARD_NO — NUMBER — 기본 키 — NOT NULL
- PARENT_ID — VARCHAR2
- TITLE — VARCHAR2
- SECRET_YN — VARCHAR2
- BOARD_PW — VARCHAR2
- TOP_YN — VARCHAR2
- DEL_YN — VARCHAR2
- CNT — NUMBER
- USER_ID — VARHCAR2
- RESERVED_DAY — DATE
- CONTENT — VARCHAR2
- ANSWER_YN — VARCHAR2
- USER_EMAIL — VARHCAR2
- USER_PHONE — VARCHAR2
- AGREEMENT — VARCHAR2
- NAME_SECRET_YN — VARCHAR2
- AMND_DD — DATE
BRD_RPLY
- RPLY_ID — NUMBER — 기본 키 — NOT NULL
- BOARD_NO — NUMBER — 기본 키 — NOT NULL
- PARENT_NO — NUMBER
- DEEP — NUMBER
- CONTENT — CLOB
- RPLY_USER — VARCHAR2
- RPLY_SECRET_YN — VARCHAR2
- RPLY_SECRET_PW — VARCHAR2
CNTR_CNT
- CNTR_CD — VARCHAR(255) — 기본 키 — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- CNTR_NM — NOT — NOT NULL
- DLY_TIME — NUMBER — NOT NULL
- MDF_DT — NOT — NOT NULL
COMMON
- COM_ID — VARCHAR2 — 기본 키 — NOT NULL
- COM_KEY — VARCHAR2 — 기본 키 — NOT NULL
- VAL_1 — VARCHAR2
- VAL_2 — VARCHAR2
- VAL_3 — VARCHAR2
FILES_BRD
- FILE_NUM — NUMBER — 외래 키 → files.FILE_NUM — NOT NULL
- CONTENT_ID — VARCHAR2 — 외래 키 → BRD_CNTNT.CONTENT_ID — NOT NULL
- BOARD_NO — NUMBER — 외래 키 → BRD_CNTNT.BOARD_NO — NOT NULL
MENU_MSTR
- MENU_ID — VARCHAR2 — 기본 키 — NOT NULL
- MENU_NM — VARCHAR2
- FOLD_YN — VARCHAR2
- PGM_ID — VARCHAR2
- MENU_SHOW_YN — VARCHAR2
- MENU_ORD — VARCHAR2
- HG_RK_MENU_ID — VARCHAR2
- MENU_GRP — VARCHAR2
NTC_BRD_DFN
- 게시판번호 — NUMBER — 기본 키 — NOT NULL
- BOARD_NAME — VARCHAR2
- EDITOR_YN — VARCHAR2
- ATTACH_YN — VARCHAR2
- REPLY_YN — VARCHAR2
- USE_YN — VARHCAR2
- CREATED_ADMIN_SEQ — VARCHAR(255)
POINT_USE_YN
- Key — VARCHAR(255) — 기본 키 — NOT NULL
- POINT_N — VARCHAR(255)
- RGS_DT — VARCHAR(255)
SEQ_TABLE
- SEQ_NO — NUMBER — 기본 키 — NOT NULL
- SEQ_NM — VARCHAR2
USER
- ID — VARCHAR2 — 기본 키 — NOT NULL
- PASSWORD — VARCHAR2
- NAME — VARCHAR2
- BIRTH — DATE
- GNDR — VARCHAR2
- EMAIL — VARCHAR2
- PHON — VARCHAR2
- GRADE — VARCHAR2
- USE — VARCHAR(255)
- INV_F — VARCHAR(50)
- EVN — VARCHAR(50)
- AGR_STT — VARCHAR(255)
- AGR_STT2 — VARCHAR(255)
- SMS_YN — VARCHAR(255)
- EMAIL_YN — VARCHAR(255)
- LOGIN_DT — VARCHAR(255)
- JOIN_DT — VARCHAR(255)
- MDF_DT — VARCHAR(255)
- USE_YN — VARCHAR(255)
USER_ADRS
- ID — VARCHAR2 — 외래 키 → USER.ID — NOT NULL
- ADDRESS — VARCHAR2
- ZIP_CD — NUMBER
- SLCT_YN — VARCHAR2
- RGS_DT — DATE
- MDF_DT — DATE
- USE_YN — VARCHAR2
Untitled
- grade — VARCHAR(255) — NOT NULL
- shipping — VARCHAR(255) — NOT NULL
- coupon — VARCHAR(255) — NOT NULL
- PAY_INFO — VARCHAR(255) — NOT NULL
- Category — VARCHAR(255) — NOT NULL
- Field5 — VARCHAR(255)
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
WISH_LIST
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- ID — VARCHAR2 — 외래 키 → USER.ID — NOT NULL
cart
- ID — VARCHAR — 외래 키 → USER.ID — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- PDT_CNT — VARCHAR(255)
file_product
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- FILE_NUM — NUMBER — 외래 키 → files.FILE_NUM — NOT NULL
- Field — VARCHAR(255)
files
- FILE_NUM — NUMBER — 기본 키 — NOT NULL
- FILE_NM — VARCHAR2
- FILE_PATH — VARCHAR2
- FILE_IMG — BLOB
- FILE — VARCHAR2
order
- ORDER_NUM — VARCHAR(255) — 기본 키 — NOT NULL
- ID — VARCHAR — 외래 키 → cart.ID — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → cart.PDT_NUM — NOT NULL
- PDT_CNT — VARCHAR(255)
- PDT_PAY — VARCHAR(255)
- PAY_INFO — VARCHAR(255)
- CA_NO — VARCHAR(255)
- ORDER_TP — VARCHAR(255)
- COUPON_YN — VARCHAR(255)
point
- POINT_NUM — VARCHAR(255) — 기본 키 — NOT NULL
- ORDER_NUM — VARCHAR(255) — 기본 키 — NOT NULL
- ID — VARCHAR — NOT NULL
- PDT_NUM — NUMBER — NOT NULL
- POINT — VARCHAR(255)
- RGS_DT — VARCHAR(255)
- MDF_DT — VARCHAR(255)
- USE_YN — VARCHAR(255)
product
- PDT_NUM — NUMBER — 기본 키 — NOT NULL
- PDT_NM — VARCHAR2
- PDT_BILL — NUMBER
- LN_INTRO — VARCHAR2
- DSCNT — NUMBER
- PCK_TP — VARCHAR2
- SALES_U — VARCHAR2
- WT_CAP — NUMBER
- ORG — VARCHAR2
- NOTICE — VARCHAR2
- EXPRT_DT — DATE
- RGS_DT — DATE
- MDF_DT — DATE
- USE_YN — VARCHAR2
product-category
- COM_ID — VARCHAR2 — 외래 키 → COMMON.COM_ID — NOT NULL
- COM_KEY — VARCHAR2 — 외래 키 → COMMON.COM_KEY — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- LEV — VARCHAR(255)
review
- REVIEW_NUM — NUMBER — 기본 키 — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → product.PDT_NUM — NOT NULL
- ID — VARCHAR2 — 외래 키 → USER.ID — NOT NULL
- RV_TITLE — VARCHAR2
- RV_COMM — VARCHAR2
- SCORE — NUMBER
- RGS_DT — DATE
- MDF_DT — DATE
- USE_YN — VARCHAR2
review-FILE
- REVIEW_NUM — NUMBER — 외래 키 → review.REVIEW_NUM — NOT NULL
- PDT_NUM — NUMBER — 외래 키 → review.PDT_NUM — NOT NULL
- ID2 — VARCHAR2 — 외래 키 → review.ID — NOT NULL
- FILE_NUM — NUMBER — 외래 키 → files.FILE_NUM — NOT NULL
- SEQ — VARCHAR(255)
user_coupon
- ID2 — VARCHAR2 — 외래 키 → USER.ID — NOT NULL
- COM_ID — VARCHAR2 — NOT NULL
- COM_KEY — VARCHAR2 — NOT NULL
- USE_DT — DATE
- STRT_DT — TIMESTAMP
- END_DT — TIMESTAMP
- ISNC — DATE