cafeProject ERD
Tables (3)
order_item (주문상품)
- id (주문상품번호) — BIGINT — Primary key — NOT NULL
- order_price (주문가격) — BIGINT — NOT NULL
- quantity (수량) — INTEGER — NOT NULL
- order_result_id (주문번호) — BIGINT — Foreign key → order_result.id — NOT NULL
- product_id (상품번호) — BIGINT — Foreign key → product.id — NOT NULL
order_result (주문)
- id (주문번호) — BIGINT — Primary key — NOT NULL
- email (주문자 이메일) — VARCHAR(255) — NOT NULL
- shipping_address (배송주소) — VARCHAR(255) — NOT NULL
- zip_code (우편번호) — VARCHAR(255) — NOT NULL
- total_price (총 주문금액) — BIGINT — NOT NULL
- shipping_date (배송예정일) — DATE
- create_date (생성일시) — TIMESTAMP(6)
- modify_date (수정일시) — TIMESTAMP(6)
product (상품)
- id (상품번호) — BIGINT — Primary key — NOT NULL
- name (상품명) — VARCHAR(255) — NOT NULL
- category (카테고리) — VARCHAR(255) — NOT NULL
- price (가격) — INTEGER — NOT NULL
- photo_url (상품이미지URL) — VARCHAR(255)
- create_date (생성일시) — TIMESTAMP(6)
- modify_date (수정일시) — TIMESTAMP(6)