mealkit
Tables (8)
address
- address_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- zipcode — VARCHAR(50) — NOT NULL
- addr — VARCHAR(50) — NOT NULL
- addr_detail — VARCHAR(50) — NOT NULL
- phone — VARCHAR(50) — NOT NULL
- request — VARCHAR(225)
categories
- categories_id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
image
- image_id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- seller_id — INT — NOT NULL
- image_path — VARCHAR(225) — NOT NULL
product
- product_id — INT — Primary key — NOT NULL
- seller_id — INT — NOT NULL
- categories_id — INT — NOT NULL
- title_name — VARCHAR(50) — NOT NULL
- summary_name — VARCHAR(500) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- sale — INT
- contents — VARCHAR(500) — NOT NULL
- product_detail — VARCHAR(500) — NOT NULL
- delivery_fee — NOT — NOT NULL
- created_date — DATE
- update_date — DATE
receipt
- receipt_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- address_id — INT — NOT NULL
- product_id — INT — NOT NULL
- sub_product_id — INT — NOT NULL
- request — VARCHAR(50)
- order_date — DATE
seller
- seller_id — INT — Primary key — NOT NULL
- company — VARCHAR(50) — NOT NULL
- address — VARCHAR(100) — NOT NULL
- phone — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- email_auth_code — VARCHAR(100)
- email_auth_create_dt — VARCHAR(100)
- registration_num — INT — NOT NULL
- create_date — DATE
- update_date — DATE
sub_product
- sub_product_id — INT — Primary key — NOT NULL
- product_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- weight — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(20) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- email_auth_code — VARCHAR(225)
- email_auth_create_dt — VARCHAR(255)
- password — VARCHAR(225) — NOT NULL
- phone — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_date — DATE
- update_date — DATE