Kylemall

Tables (10)

chat_message

  • message_id — BIGINT
  • room_id — VARCHAR(50) — NOT NULL
  • sender — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • message — TEXT — NOT NULL
  • message_type — VARCHAR(10) — NOT NULL
  • sent_at — TIMESTAMP

chat_room

  • room_id — VARCHAR(50)
  • room_name — VARCHAR(100) — NOT NULL
  • created_by — VARCHAR(50) — NOT NULL
  • room_admin — VARCHAR(50) — NOT NULL
  • room_password — VARCHAR(100)
  • max_users — INT
  • current_users — INT
  • created_at — TIMESTAMP

chat_room_participant

  • room_id — VARCHAR(50)
  • member_id — VARCHAR(50)
  • joined_at — TIMESTAMP

faq

  • faq_no — INTEGER
  • faq_title — VARCHAR(50) — NOT NULL
  • faq_content — VARCHAR(10000) — NOT NULL
  • faq_reg_date — TIMESTAMP — NOT NULL

orderdetail

  • detail_id — INTEGER
  • detail_quantity — INTEGER — NOT NULL
  • merchant_uid — VARCHAR(50) — NOT NULL
  • product_no — INTEGER — NOT NULL

orders

  • merchant_uid — VARCHAR(50)
  • member_id — VARCHAR(50) — NOT NULL
  • total_amount — INTEGER — NOT NULL
  • order_status — VARCHAR(10)
  • product_title — VARCHAR(50) — NOT NULL
  • order_msg — VARCHAR(300)
  • order_created_at — TIMESTAMP
  • order_updated_at — TIMESTAMP

payment

  • imp_uid — VARCHAR(50)
  • merchant_uid — VARCHAR(50) — NOT NULL
  • payment_method — VARCHAR(50) — NOT NULL
  • payment_status — ENUM('PENDING', 'PAID', 'CANCELLED', 'FAILED')
  • amount — INTEGER — NOT NULL
  • paid_at — TIMESTAMP
  • cancelled_at — TIMESTAMP
  • payment_created_at — TIMESTAMP
  • payment_updated_at — TIMESTAMP

product

  • product_no — INTEGER
  • product_name — VARCHAR(50) — NOT NULL
  • product_description — TEXT — NOT NULL
  • product_price — INTEGER — NOT NULL
  • stock_quantity — INTEGER — NOT NULL
  • image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • category_no — INTEGER — NOT NULL
  • sale_ok — TINYINT(1) — NOT NULL
  • sale_price — INTEGER

shipping

  • shipping_id — INTEGER
  • merchant_uid — VARCHAR(50) — NOT NULL
  • recipient_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(15) — NOT NULL
  • delivery_status — ENUM('배송 준비 중', '배송 중', '배송 완료', '배송 취소')
  • tracking_number — VARCHAR(50)
  • shipping_date — DATETIME
  • estimated_arrival — DATETIME
  • shipping_msg — VARCHAR(300)
  • shipping_created_at — TIMESTAMP
  • shipping_updated_at — TIMESTAMP

shoppingcart

  • cart_id — INTEGER
  • quantity — INTEGER — NOT NULL
  • added_at — TIMESTAMP
  • member_id — VARCHAR(50) — NOT NULL
  • product_no — INTEGER — NOT NULL