pos
Tables (12)
admin
- admin_id — INT — Primary key — NOT NULL
- username — VARCHAR(30)
- userid — VARCHAR(20)
- userpw — VARCHAR(20)
- phone1 — INT
- phone2 — INT
- phone3 — INT
cart
- cart_id — INT — Primary key — NOT NULL
- customer_id — INT
- product_id — INT
category
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(50)
- scale_type — VARCHAR(50)
customer
- customer_id — INT — NOT NULL
- username — VARCHAR(30)
- userid — VARCHAR(20)
- userpw — VARCHAR(20)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(100)
- email1 — VARCHAR(100)
- email2 — VARCHAR(100)
- phone1 — INT
- phone2 — INT
- phone3 — INT
- points — INT
- birthdate — DATETIME
delivery_addr
- delivery_addr_id — INT — Primary key — NOT NULL
- customer_id — INT
- addr_type — VARCHAR(30)
- addr1 — VARCHAR(100)
- addr2 — VARCHAR(100)
- post — INT
- phone1 — INT
- phone2 — INT
- phone3 — INT
- is_default — BOOL
delivery_state
- delivery_id — INT — Primary key — NOT NULL
- delivery_state — VARCHAR(50)
discount
- discount_id — INT — Primary key — NOT NULL
- discount_type — VARCHAR(50)
- discount_rate — DOUBLE
- start_date — DATETIME
- end_date — DATETIME
- discount_date — DATETIME
membership
- membership_id — INT — Primary key — NOT NULL
- membership_grade — VARCHAR(50)
- customer_id — INT
- amount — INT
- points — INT
- rating — DOUBLE
order
- order_id — INT — Primary key — NOT NULL
- customer_id — INT
- product_name — VARCHAR(100)
- product_amount — INT
- product_image — VARCHAR(300)
- final_price — INT
- order_date — DATETIME
- delivery_id — INT
payment
- payment_id — INT — Primary key — NOT NULL
- total_price — INT
- discount_price — INT
- delivery_fee — INT
- final_price — INT
- payment_date — DATETIME
- order_id — INT
- points — INT
product
- product_id — INT — Primary key — NOT NULL
- product_name — VARCHAR(50)
- product_price — INT
- product_image — VARCHAR(300)
- product_description — VARCHAR(100)
- category_name — VARCHAR(20)
- scale — DOUBLE
- product_date — DATETIME
- product_qr — VARCHAR(300)
- discount_id — INT
review
- product_id — INT — Primary key — NOT NULL
- contents — VARCHAR(300)
- review_image — VARCHAR(300)
- rating — DOUBLE