erd_최종
테이블 (9)
address
- idx — INT — 기본 키 — NOT NULL
- address — VARCHAR(50)
- detail_address — VARCHAR(50)
- user_idx — INT
- create_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(7)
order_product
- order_id — INT — 외래 키 → orders.idx — NOT NULL
- product_id — INT — 외래 키 → product.id — NOT NULL
- quantity — INT — NOT NULL
orders
- idx — INT — 기본 키 — NOT NULL
- address — VARCHAR(100)
- store_idx — INT
- product_id — INT
- order_price — INT
- delivery_price — INT
- discount_price — INT
- total_price — INT
product
- id — INT — 기본 키 — NOT NULL
- field — VARCHAR(50)
- price — INT
- introduction — VARCHAR(500)
- remain — INT
- store_id — INT
review
- id — INT — 기본 키 — NOT NULL
- contents — VARCHAR(500)
- rating — DOUBLE
- store_id — INT
- product_id — INT
- img — TEXT
- written_date — DATETIME
- r_status — BOOL
review_backup
- id — INT — 기본 키 — NOT NULL
- contents — VARCHAR(500)
- rating — DOUBLE
- store_id — INT
- product_id — INT
- img — TEXT
- written_date — DATETIME
- r_status — BOOL
- deleted_date — DATETIME
store
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(50)
- phone — VARCHAR(20)
- address — VARCHAR(80)
- introduction — VARCHAR(500)
- rocket — BOOL
- delivery_time — VARCHAR(20)
user
- idx — INT — 기본 키 — NOT NULL
- email — VARCHAR(45)
- password — VARCHAR(255)
- name — VARCHAR(30)
- phone — VARCHAR(20)
- address_idx — INT
- pay_type — VARCHAR(8)
user_address
- user_idx — INT — 외래 키 → user.idx — NOT NULL
- address_idx — INT — 외래 키 → address.idx — NOT NULL