442
Tables (6)
Address
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(50)
- detailAddress — VARCHAR(50)
- alias — VARCHAR(50)
- useridx — INT — Foreign key → User.idx
- createAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(7)
Orders
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(100) — Foreign key → Address.address
- storeIdx — INT
- orderPrice — INT
- deliveryPrice — INT
- discountPrice — INT
- totalPrice — INT
PRODUCT
- product_id — INT — Primary key — NOT NULL
- Field — VARCHAR(50)
- product_price — INT
- product_introduction — VARCHAR(500)
- product_remain — INT
REVIEW
- review_id — INT — Primary key — NOT NULL
- review_contents — VARCHAR(500)
- review_rating — DOUBLE
- stord_id — INT — Foreign key → STORE.store_id
- product_id — INT
- review_img — TEXT
- review_created — DATETIME
- review_status — BOOL
STORE
- store_id — INT — Primary key — NOT NULL
- store_name — VARCHAR(50)
- store_phone — VARCHAR(20)
- store_address — VARCHAR(80)
- store_CEO_name — VARCHAR(10)
- store_introduction — VARCHAR(500)
- store_rocket — BOOL
- store_delivery_time — VARCHAR(20)
User
- idx — INT — Primary key — NOT NULL
- email — VARCHAR(45)
- password — VARCHAR(255)
- userName — VARCHAR(30)
- phone — VARCHAR(20)
- addressIdx — INT — Foreign key → Address.idx
- payTyep — VARCHAR(8)