데브코스-3기-1차프로젝트-3팀

테이블 (8)

tbl_addresses

  • address_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → tbl_members.member_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_cart_products

  • cart_product_id — BIGINT — 기본 키 — NOT NULL
  • cart_id — BIGINT — 외래 키 → tbl_carts.cart_id — NOT NULL
  • product_id — BIGINT — 외래 키 → tbl_products.product_id — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_carts

  • cart_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → tbl_members.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_deliveries

  • delivery_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → tbl_orders.order_id — NOT NULL
  • member_id — BIGINT — 외래 키 → tbl_members.member_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_members

  • member_id — BIGINT — 기본 키 — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(255) — NOT NULL
  • roles — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_orders

  • order_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → tbl_members.member_id — NOT NULL
  • amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_payments

  • payment_id — BIGINT — 기본 키 — NOT NULL
  • order_id — BIGINT — 외래 키 → tbl_orders.order_id — NOT NULL
  • member_id — BIGINT — 외래 키 → tbl_members.member_id — NOT NULL
  • method — VARCHAR(255) — NOT NULL
  • paid_amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

tbl_products

  • product_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • image — VARCHAR(255)
  • stock — INT
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME