asd
Tables (6)
Address
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(50)
- detailAddress — VARCHAR(50)
- alias — VARCHAR(50)
- useridx — INT
- createAt — TIMESTAMP
- updatedAt — TIMESTAMP
- status — VARCHAR(7)
Orders
- idx — INT — Primary key — NOT NULL
- address — VARCHAR(100)
- 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
- product_id — INT
- review_img — txt
- 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
- payTyep — VARCHAR(8)