coupang
Tables (8)
Comment (ORDER)
- COMMENT_ID (ORDER_ID) — BIGINT — Primary key — NOT NULL — 구분자
- USERS_ID — BIGINT — Foreign key → USERS.USERS_ID — NOT NULL
- CONTENTS (TOTALPRICE) — DOUBLE — NOT NULL
- INP_DATE (STATUS) — STRING — NOT NULL
DIARY (ITEM)
- DIARY_ID (ITEM_ID) — BIGINT — Primary key — NOT NULL — 구분자
- Field (ITEMNAME) — VARCHAR — NOT NULL
- Field (ITEMPRICE) — DOUBLE — NOT NULL
- Field (ITEMDETAIL) — VARCHAR — NOT NULL
PHOTO_FILE (ORDERDETAIL)
- PHOTO_ID (ORDERDETAIL_ID) — BIGINT — Primary key — NOT NULL — 구분자
- FILE_NAME (PRICE) — DOUBLE — NOT NULL
- COMMENT_ID (ORDER_ID) — BIGINT — Foreign key → Comment.COMMENT_ID — NOT NULL — 구분자
- DIARY_ID (ITEM_ID) — BIGINT — Foreign key → DIARY.DIARY_ID — NOT NULL — 구분자
REGION (ADDRESS)
- REGION_ID (ADDRESS_ID) — BIGINT — Primary key — NOT NULL — 구분자
- REGION_NAME (ZIPCODE) — VARCHAR — NOT NULL — 우편주소
- NX (ADDRESSDETAIL) — VARCHAR — NOT NULL — 상세주소
- NY (RECIEVER) — VARCHAR — NOT NULL — 받는 사람
- USERS_ID — BIGINT — Foreign key → USERS.USERS_ID — NOT NULL — 구분자
- Field (RECIEVERNUM) — VARCHAR — NOT NULL — 받는 사람 번호
USERS (MEMBER)
- USERS_ID (MEMBER_ID) — BIGINT — Primary key — NOT NULL — 구분자
- EMAIL — VARCHAR — NOT NULL — 이메일
- PASSWORD — VARCHAR — NOT NULL — 비밀번호
- BIRTH_DAY (NAME) — VARCHAR — NOT NULL — 이름
Untitled (CARTDETAIL)
- Key (CARTDETAIL_ID) — BIGINT — Primary key — NOT NULL
- Field (CARTDETAILTOTAL) — BIGINT — NOT NULL
- Key (CART_ID) — BIGINT — Foreign key → VIEWER.Key — NOT NULL — 구분자
- DIARY_ID (ITEM_ID) — BIGINT — Foreign key → DIARY.DIARY_ID — NOT NULL — 구분자
Untitled (SHIPMENT)
- Key (SHIPMENT_ID) — BIGINT — Primary key — NOT NULL
- Field (SHIPMENTSTATUS) — STRING — NOT NULL
- Field2 (ARRIVALDATE) — DATE — NOT NULL
- COMMENT_ID (ORDER_ID) — BIGINT — Foreign key → Comment.COMMENT_ID — NOT NULL — 구분자
VIEWER (CART)
- Key (CART_ID) — BIGINT — Primary key — NOT NULL — 구분자
- USERS_ID — BIGINT — Foreign key → USERS.USERS_ID — NOT NULL
- INP_DATE (CARTTOTAL) — DOUBLE — NOT NULL — 생성일