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