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 — 생성일