DoYack
Tables (17)
cart
- product_code — VARCHAR(4)
- product_count — INT — NOT NULL
- user_id — VARCHAR(4)
coupon
- coupon_code — VARCHAR(4)
- discount_rate — INT — NOT NULL
- validity_period — INT — NOT NULL
- expiration_date — DATE — NOT NULL
- minimum_purchase_amount — INT — NOT NULL
- applicable_product — VARCHAR(50)
- excluded_product — VARCHAR(50)
delivery
- delivery_number — VARCHAR(4)
- user_id — VARCHAR(4) — NOT NULL
- order_number — VARCHAR(4) — NOT NULL
- tracking_number — VARCHAR(20)
- delivery_status — VARCHAR(20) — NOT NULL
delivery_address
- user_id — VARCHAR(4)
- default_address_flag — VARCHAR(1) — NOT NULL
- address — VARCHAR(100) — NOT NULL
ingredient
- product_code — VARCHAR(4)
- ingredient — VARCHAR(50) — NOT NULL
order
- order_number — VARCHAR(4)
- user_id — VARCHAR(4) — NOT NULL
- payment_method — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- order_date — DATE — NOT NULL
order_product
- order_number — VARCHAR(4)
- product_code — VARCHAR(4)
- product_count — INT — NOT NULL
- applied_coupon_code — VARCHAR(4)
- price — INT — NOT NULL
- discounted_price — INT — NOT NULL
point_history
- user_id — VARCHAR(4)
- description — VARCHAR(50) — NOT NULL
- point — INT — NOT NULL
- date — DATE — NOT NULL
product
- product_code — VARCHAR(4)
- product_name — VARCHAR(50) — NOT NULL
- product_price — VARCHAR(10) — NOT NULL
- category — VARCHAR(20) — NOT NULL
- product_notice — TEXT
- registration_date — DATE — NOT NULL
- product_description — TEXT
product_image
- product_code — VARCHAR(4)
- thumbnail_image — VARCHAR(100) — NOT NULL
- main_image — VARCHAR(100) — NOT NULL
- detail_page_image — VARCHAR(100)
product_tag
- product_code — VARCHAR(4)
- tag — VARCHAR(20) — NOT NULL
question
- question_code — VARCHAR(4)
- product_code — VARCHAR(4)
- question_text — TEXT — NOT NULL
review
- review_code — VARCHAR(4)
- product_code — VARCHAR(4) — NOT NULL
- user_id — VARCHAR(4) — NOT NULL
- order_code — VARCHAR(4) — NOT NULL
- like_count — INT — NOT NULL
- star_rating — INT — NOT NULL
- registration_date — DATE — NOT NULL
- review_text — TEXT
review_image
- review_code — VARCHAR(4)
- review_image — VARCHAR(100) — NOT NULL
satisfaction
- review_code — VARCHAR(4)
- delivery_satisfaction — INT — NOT NULL
- product_satisfaction — INT — NOT NULL
- health_help_satisfaction — INT — NOT NULL
- service_satisfaction — INT — NOT NULL
user
- id — VARCHAR(4)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- contact_number — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- birth_year — YEAR — NOT NULL
- point — INT — NOT NULL
user_coupon
- user_id — VARCHAR(4)
- coupon_code — VARCHAR(4)
- issuance_date — DATE — NOT NULL