Web-Shopping-DB
Tables (14)
answer
- answer_id — bigint — Primary key
- created_date — datetime
- last_modified_date — datetime
- comment — longtext — ongtext nul
- qna_status — varchar(255)
cart
- cart_id — bigint — Primary key
- cart_item_id — bigint — Foreign key → cart_item.cart_item_id
- user_id — bigint — Foreign key → users.user_id
- answer_id — bigint — Foreign key → users.answer_id
- created_date — datetime
- last_modified_date — datetime
cart_item
- cart_item_id — bigint — Primary key
- item_count — int
image
- image_id — bigint — Primary key
- category — varchar(31) — NOT NULL
- created_date — datetime
- last_modified_date — datetime
- ext — varchar(255)
- hash — varchar(255)
- image_order — int — NOT NULL
- image_path — varchar(255)
- is_representative — bit — NOT NULL
- original_name — varchar(255)
- thumbnail_path — varchar(255)
- upload_name — varchar(255)
- item_id — bigint
- notice_id — bigint
- review_id — bigint
item
- item_id — bigint — Primary key
- default_option_id — bigint — Foreign key → item_option.item_option_id
- cart_item_id — bigint — Foreign key → item_option.cart_item_id
- picked_id — bigint — Foreign key → picked_item.picked_id
- user_id — bigint — Foreign key → picked_item.user_id
- created_date — datetime
- last_modified_date — datetime
- category — varchar(255)
- delivery_price — int — NOT NULL
- description — longtext
- discount_rate — int
- item_name — varchar(255) — NOT NULL
- item_price — int — NOT NULL
- item_status — varchar(255)
- sales_quantity — int — NOT NULL
- view_count — bigint — NOT NULL
item_option
- item_option_id — bigint — Primary key
- item_id — bigint — Foreign key → item.item_id
- cart_item_id — bigint — Foreign key → cart_item.cart_item_id
- picked_id — bigint — Foreign key → item.picked_id
- user_id — bigint — Foreign key → item.user_id
- additional_price — int
- default_option — bit — NOT NULL
- item_count — int
- option_detail — varchar(255)
- option_name — varchar(255)
notice
- notice_id — bigint — Primary key
- user_id — bigint — Foreign key → users.user_id
- answer_id — bigint — Foreign key → users.answer_id
- created_date — datetime
- last_modified_date — datetime
- content — longtext
- notice_category — varchar(255)
- title — varchar(255)
- view_count — bigint — NOT NULL
ordered_item
- order_item_id — bigint — Primary key
- created_date — datetime
- last_modified_date — datetime
- discount_rate — int — NOT NULL
- discounted_price — int — NOT NULL
- item_count — int — NOT NULL
- item_details — varchar(255)
- option_details — varchar(255)
- price — int — NOT NULL
- item_item_id — bigint
- item_option_id — bigint
- order_id — bigint
orders
- order_id — bigint — Primary key
- shipping_info_id — bigint — Foreign key → shipping_info.shipping_info_id
- user_id (user_id2) — bigint — Foreign key → shipping_info.user_id
- answer_id — bigint — Foreign key → shipping_info.answer_id
- created_date — datetime
- last_modified_date — datetime
- address_detail — varchar(255)
- address_simple — varchar(255)
- phone — varchar(255)
- zip_code — varchar(255)
- delivery_company — varchar(255)
- delivery_date — date
- delivery_price — int — NOT NULL
- message — varchar(255)
- order_number — varchar(255)
- orders_status — varchar(255)
- recipient — varchar(255)
- tracking_number — varchar(255)
- user_id — bigint
picked_item
- picked_id — bigint — Primary key
- user_id — bigint — Foreign key → users.user_id
question
- question_id — bigint — Primary key
- created_date — datetime
- last_modified_date — datetime
- comment — longtext — ongtext nul
- qna_status — varchar(255)
- answer_id — bigint
- item_id — bigint
- user_id — bigint
review
- review_id — bigint — Primary key — NOT NULL
- created_date — datetime
- last_modified_date — datetime
- best — bit — NOT NULL
- comment — varchar(255) — archar(255) nul
- rating — int
- item_id — bigint
- user_id — bigint
shipping_info
- shipping_info_id — bigint — Primary key
- user_id (user_id2) — bigint — Foreign key → users.user_id
- answer_id — bigint — Foreign key → users.answer_id
- address_detail — varchar(255)
- address_simple — varchar(255)
- phone — varchar(255)
- zip_code — varchar(255)
- recipient — varchar(255)
users
- user_id — bigint — Primary key
- answer_id — bigint — Foreign key → answer.answer_id
- created_date — datetime
- last_modified_date — datetime
- email — varchar(255)
- grade — varchar(255)
- last_connected_date — datetime
- nick_name — varchar(255)
- password — varchar(255)
- phone — varchar(255)
- profile_image — varchar(255)
- provider_id — varchar(255)
- user_name — varchar(255)
- user_role — varchar(255)
- user_status — varchar(255)