erd13
Tables (8)
address
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(50)
- detail_address — VARCHAR(50)
- user_idx — INT
- create_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(7)
orders
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(100) — Foreign key → address.address
- store_idx — INT
- product_id — INT
- order_price — INT
- delivery_price — INT
- discount_price — INT
- total_price — INT
product
- id — INT — Primary key — NOT NULL
- field — VARCHAR(50)
- price — INT
- introduction — VARCHAR(500)
- remain — INT
- store_id — INT — Foreign key → store.id
review
- id — INT — Primary key — NOT NULL
- contents — VARCHAR(500)
- rating — DOUBLE
- store_id — INT — Foreign key → store.id
- product_id — INT
- img — TEXT
- written_date — DATETIME
- status — BOOL
review_backup
- id — INT — Primary key — NOT NULL
- contents — VARCHAR(500)
- rating — DOUBLE
- store_id — INT
- product_id — INT
- img — TEXT
- written_date — DATETIME
- status — BOOL
store
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
- phone — VARCHAR(20)
- address — VARCHAR(80)
- introduction — VARCHAR(500)
- rocket — BOOL
- delivery_time — VARCHAR(20)
user
- idx — INT — Primary key — 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 — Foreign key → user.idx — NOT NULL
- address_idx — INT — Foreign key → address.idx — NOT NULL