shoppingmall
Tables (18)
address
- addr_no — bigInt — Primary key — NOT NULL
- user_no — BIGINT — Foreign key → users.user_no — NOT NULL
- user_no (user_no2) — BIGINT — Foreign key → orders.user_no — NOT NULL
- addr_name — varchar(4000)
- addr_contact — varchar(20)
- addr_zipcode — int
- addr_address — varchar(100)
- addr_detail — varchar(100)
- addr_request — varchar(255)
- is_default — boolean
- is_liked — boolean
- last_used — date
cart
- cart_id — BIGINT — Primary key — NOT NULL
- user_no — BIGINT — Foreign key → users.user_no — NOT NULL
- total_count — int
cart_item
- cart_item_id — BIGINT — Primary key — NOT NULL
- cart_id — BIGINT — Foreign key → cart.cart_id — NOT NULL
- item_id — bigint — Foreign key → item.item_id — NOT NULL
- is_selected — boolean
- quantity — int
- added_date — Datetime
category
- category_id — BIGINT — Primary key — NOT NULL
- category_name — varchar(100)
faq_board
- faq_id — BIgInt — Primary key — NOT NULL
- category — varchar(100)
- title — varchar(100)
- content — text
- reg_date — varchar(100)
item
- item_id — int — Primary key — NOT NULL
- sub_category_id — int — Foreign key → sub_category.sub_category_id — NOT NULL
- item_name — varchar(100)
- category_id — int
- item_size (size) — varchar(200)
- item_description (text) — varchar(4000)
- price — int
- discount_rate — int
- discounted_price — int
- discount_start — date
- discount_end — date
- discount_description (discount_desc) — varchar(4000)
- stock — varchar(4000)
- main_photo (photo) — varchar(4000)
- detail_photo (detail) — varchar(4000)
notice_board
- notice_id — BIgInt — Primary key — NOT NULL
- user_no — BIGINT — Foreign key → users.user_no — NOT NULL
- title — varchar(2000)
- content — text
- reg_date — datetime
- image
order_items
- order_item_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- user_no — BIGINT — Foreign key → orders.user_no — NOT NULL
- item_id — bigint — Foreign key → item.item_id — NOT NULL
- quantity — int
- original_price — BIGINT
- discounted_price — BIGINT
orders
- order_id — BIGINT — Primary key — NOT NULL
- user_no — BIGINT — Foreign key → users.user_no — NOT NULL
- addr_no — BIGINT
- order_date — datetime
- delivery_done — boolean
- payment_done — boolean
- refund_change_done — boolean
payment
- payment_id — BigInt — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- user_no — BIGINT — Foreign key → orders.user_no — NOT NULL
- payment_status — varchar(10)
- payment_method — varchar(10)
- payment_date — datetime
- total_amount — BigInt
qna_answer
- answer_id — BigInt — Primary key — NOT NULL
- question_id — bigint — Foreign key → qna_board.question_id — NOT NULL
- answer — text
- created_date — datetime
qna_board
- question_id — bigint — Primary key — NOT NULL
- item_id (Key2) — bigint — Foreign key → item.item_id — NOT NULL
- user_no
- qna_category — varchar(200)
- content (Field3) — text
- attachment — varchar(2000)
- is_done — boolean
- created_date — datetime
refund_change
- refund_id — BigInt — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- delivery_contact — int
- delivery_name — varchar(100)
- delivery_zipcode — int
- delivery_addr — varchar(100)
- delivery_addr_detail — varchar(100)
- refund_change_type — int
- refund_method — longtext
- tracking_num — varchar(30)
- reason_category — varchar(10)
- reason_text — longtext
- is_done — boolean
- update_date — datetime
review
- review_id — int — Primary key — NOT NULL
- item_id — bigint — Foreign key → item.item_id — NOT NULL
- user_no — int
- rating — int
- content — text
- review_image — varchar
- created_date — datetime
shipment
- shipment_id — BIGINT — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id — NOT NULL
- user_no — BIGINT — Foreign key → orders.user_no — NOT NULL
- tracking_num — varchar(30)
- tracking_date — datetime
- delivery_status — varchar(10)
sub_category
- sub_category_id — int — Primary key — NOT NULL
- category_id — int — Foreign key → category.category_id — NOT NULL
- sub_category_name — varchar(100)
users
- user_no — BIGINT — Primary key — NOT NULL
- name — varchar(100)
- user_id — varchar(100)
- password — varchar(4000)
- email — varchar(100)
- address — varchar(4000)
- phone — varchar(100)
- create_date — date
- birth — date
- role — varchar(100)
- provider — varchar(200)
- provider_id (Field)
verification_code (Untitled)
- email — varchar(100) — Primary key — NOT NULL
- code — varchar(10)
- created_at — timestamp