와인샵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