pda 실습

테이블 (7)

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME

order_item

  • order_item_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → orders.order_id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • option_id — BIGINT — 외래 키 → product_option.option_id
  • product_name — VARCHAR(100) — NOT NULL
  • option_name — VARCHAR(100)
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • subtotal_amount — INT — NOT NULL

orders

  • order_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • order_number — VARCHAR(50) — NOT NULL
  • order_date — DATETIME — NOT NULL
  • total_quantity — INT — NOT NULL
  • total_amount — INT — NOT NULL
  • order_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

product

  • product_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

product_image

  • product_image_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • image_order — INT — NOT NULL
  • is_thumbnail — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

product_option

  • option_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • option_name — VARCHAR(100) — NOT NULL
  • additional_price — INT — NOT NULL
  • stock_quantity — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

wishlist

  • wishlist_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • product_id — BIGINT — 외래 키 → product.product_id — NOT NULL
  • created_at — DATETIME — NOT NULL