와인샵ERD

테이블 (12)

고객 혹은 판매자 (MEMBER)

  • Key (MEMBER_ID) — BIGINT — 기본 키 — NOT NULL
  • Field (EMAIL) — varchar(255)
  • Field (PASSWORD) — varchar(255)
  • Field (NICKNAME) — varchar(255)

고객쿠폰 (MEMBER_COUPON)

  • Key (MEMBER_COUPON_ID) — BIGINT — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — BIGINT — 외래 키 → 고객 혹은 판매자.Key — NOT NULL
  • key (COUPON_ID2) — 외래 키 → 쿠폰.key — NOT NULL
  • Field (IS_USED) — boolean
  • Field (iSSUED_TIME) — TIMESTAMP
  • Field (EXPIRE_TIME) — TIMESTAMP
  • Field (USED_TIME) — TIMESTAMP
  • Field

배송지 (ADDRESS)

  • Key (ADDRESS_ID) — BIGINT — 기본 키 — NOT NULL
  • Key (MEMBER_ID) — BIGINT — 외래 키 → 고객 혹은 판매자.Key — NOT NULL
  • Field (ADDRESS) — varchar(255)
  • Field (ADDRESS_DETAIL) — varchar(255)
  • Field (POSTAL_CODE) — varchar(50)
  • Field (CITY) — varchar(100)
  • Field (ORDER) — TINYINT

와인 (WINE)

  • PK (WINE_ID) — BIGINT — 기본 키 — NOT NULL
  • FK 1 (REGION_ID) — BIGINT — 외래 키 → 지역.PK — NOT NULL
  • Field 1 (NAME) — VARCHAR(255)
  • Field 2 (DESCRIPTION) — TEXT
  • Field 4 (ALCHOL_PERCENTAGE) — DECIMAL(3,1)
  • Field 5 (CREATED_AT) — TIMESTAMP
  • Field 6 (UPDATED_AT) — TIMESTAMP
  • Field 7 (DELETED_AT) — TIMESTAMP
  • Field (SELLER) — VARCHAR(255)

와인 카테고리 (WINE_CATEGORY)

  • PK (WINE_CATEGORY_ID) — BIGINT — 기본 키 — NOT NULL
  • FK1 (WINE_ID) — BIGINT — 외래 키 → 와인.PK — NOT NULL
  • FK2 (CATEGORY_ID) — BIGINT — 외래 키 → 카테고리.CATEGORY_ID — NOT NULL
  • Field 1 (CREATED_AT) — TIMESTAMP
  • Field 2 (UPDATED_AT) — TIMESTAMP

와인_판매 (WINE_SALE)

  • PK (WINE_SALE_ID) — BIGINT — 기본 키 — NOT NULL
  • FK1 (SELLER_ID) — BIGINT — 외래 키 → 고객 혹은 판매자.Key — NOT NULL
  • PK (WINE_ID) — BIGINT — 외래 키 → 와인.PK — NOT NULL
  • Field (PRICE) — INTEGER
  • Field (REGISTERD_QUANTITY) — INTEGER
  • Field (STOCK_QUANTITY) — INTEGER
  • Field (SOLD_QUANTITY) — INTEGER
  • Field 1 (SALE_STATUS) — SMALLINT
  • Field 2 (SALE_START_TIME) — timestamptz
  • Field 3 (SALE_END_TIME) — timestamptz
  • Field 4 (CREATED_AT) — timestamp
  • Field 5 (UPDATED_AT) — timestamp

장바구니 상품 (CART_WINE)

  • PK (CART_ID) — BIGINT — 기본 키 — NOT NULL
  • UK1 (MEMBER_ID) — BIGINT — 외래 키 → 고객 혹은 판매자.Key — NOT NULL
  • PK (WINE_SALE_ID) — BIGINT — 외래 키 → 와인_판매.PK — NOT NULL
  • Field (WINE_QUANTITY) — INTEGER

주문 (ORDER)

  • PK (ORDER_ID) — BIGINT — 기본 키 — NOT NULL
  • UK3 (MEMBER_ID) — BIGINT — 외래 키 → 고객 혹은 판매자.Key — NOT NULL
  • Field 1 (CREATED_AT) — TIMESTAMP — NOT NULL
  • Field 2 (UPDATED_AT) — TIMESTAMP
  • Field 3 (RECEIVER_PHONE_NUMBER) — VARCHAR(11)
  • Field 4 (RECEIVER_NAME) — VARCHAR(20)
  • Field 5 (RSRV_DATE) — VARCHAR(255)
  • Field 6 (STATUS) — INTEGER
  • Field 7 (RECEIVER_ADDR) — VARCHAR(255)
  • Field 8 (RECEIVER_ADDR_DETAIL) — VARCHAR(255)
  • Field (TOTAL_PRICE) — INTEGER
  • Field (FINAL_PRICE) — INTEGER

주문상품 (ORDER_DETAIL)

  • PK (ORDER_DETAIL_ID) — BIGINT — 기본 키 — NOT NULL
  • UK1 (ORDER_ID) — BIGINT — 외래 키 → 주문.PK — NOT NULL
  • PK (WINE_SALE_ID) — BIGINT — 외래 키 → 와인_판매.PK — NOT NULL
  • Field 1 (QUAINTITY) — INTEGER
  • Field 2 (ORIGIN_PRICE) — INTEGER
  • Field 3 (SALE_PRICE) — INTEGER

지역 (REGION)

  • PK (REGION_ID) — BIGINT — 기본 키 — NOT NULL
  • Field 1 (NAME) — VARCHAR(255)
  • Field 2 (CREATED_AT) — TIMESTAMP
  • Field 3 (UPDATED_AT) — TIMESTAMP

카테고리 (CATEGORY)

  • CATEGORY_ID (PK) — BIGINT — 기본 키 — NOT NULL
  • NAME (Field) — VARCHAR(255)
  • CREATED_AT (Field2) — TIMESTAMP
  • UPDATED_AT (Field3) — TIMESTAMP

쿠폰 (COUPON)

  • key (COUPON_ID) — 기본 키 — NOT NULL
  • Field (COUPON_CODE) — VARCHAR(30)
  • Field (DESCRIPTION) — VARCHAR(255)
  • Field (DISCOUNT_TYPE) — enum(percent,amount)
  • Field (DISCOUNT_VALUE) — INTEGER
  • Field (EXPIRE_TIME) — TIMESTAMP
  • Field (CREATE_TIME) — TIMESTAMP