데브코스-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