test

Tables (18)

attachment

  • attach_id — BIGINT
  • ref_type — VARCHAR(20)
  • ref_id — BIGINT
  • image_url — VARCHAR(500)
  • origin_name — VARCHAR(255)
  • is_thumbnail — BOOLEAN
  • created_at — DATETIME

bids

  • bid_id — BIGINT
  • request_id — BIGINT
  • business_id — BIGINT
  • price — BIGINT
  • duration_days — BIGINT
  • as_available — TINYINT(1)
  • comment — TEXT — EX
  • status — VARCHAR(20)
  • selected_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

bizinfo

  • bizinfo_id — BIGINT
  • title — VARCHAR(255)
  • biz_description — TEXT
  • dimension — VARCHAR(100)
  • location — VARCHAR(255)
  • order_id — BIGINT
  • business_id — BIGINT

business

  • business_id — BIGINT
  • login_id — VARCHAR(50)
  • company_name — VARCHAR(100)
  • password_hash — VARCHAR(255)
  • phone_number — VARCHAR(20)
  • address — VARCHAR(255)
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

business_settlement

  • id — BIGINT
  • business_id — BIGINT
  • order_id — BIGINT
  • sales_amount — BIGINT
  • commission_amount — BIGINT
  • settlement_amount — BIGINT
  • settlement_status — VARCHAR(20)
  • created_at — DATETIME

career

  • career_id — BIGINT
  • bizinfo_id — BIGINT
  • work_description — TEXT

cart

  • cart_id — BIGINT
  • customer_id — BIGINT
  • created_at — DATETIME

cart_items

  • cart_item_id — BIGINT
  • kit_id — BIGINT
  • cart_id — BIGINT
  • quantity — BIGINT
  • created_at — DATETIME

category

  • category_id — BIGINT
  • name — VARCHAR(50)

chat_function

  • room_id — BIGINT
  • business_id — BIGINT
  • customer_id — BIGINT
  • last_read_at — DATETIME
  • is_pinned — BOOLEAN

chat_message

  • message_id — BIGINT
  • room_id — BIGINT
  • sender_id — BIGINT
  • message_type — VARCHAR(20)
  • content — TEXT
  • is_read — BOOLEAN
  • send_at — DATETIME

chat_room

  • room_id — BIGINT
  • bid_id — BIGINT
  • customer_id — BIGINT
  • business_id — BIGINT
  • created_at — DATETIME

customer

  • customer_id — BIGINT
  • login_id — VARCHAR(50)
  • email — VARCHAR(100)
  • nickname — VARCHAR(50)
  • password_hash — VARCHAR(255)
  • phone_number — VARCHAR(20)
  • address — VARCHAR(255)
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

kit

  • kit_id — BIGINT
  • business_id — BIGINT
  • name — VARCHAR(255)
  • manufacturer — VARCHAR(255)
  • price — BIGINT
  • stock — BIGINT
  • created_at — DATETIME

order_items

  • order_item_id — BIGINT
  • order_id — BIGINT
  • kit_id — BIGINT
  • price — BIGINT
  • quantity — BIGINT

orders

  • order_id — BIGINT
  • order_no — VARCHAR(50)
  • customer_id — BIGINT
  • business_id — BIGINT
  • total_amount — BIGINT
  • payment_status — VARCHAR(20)
  • payment_method — VARCHAR(20)
  • created_at — DATETIME
  • duedate — DATETIME

request

  • request_id — BIGINT
  • customer_id — BIGINT
  • category_id — BIGINT
  • title — VARCHAR(200)
  • description — TEXT
  • hope_price — BIGINT
  • hope_period — BIGINT
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

social_login

  • social_id — BIGINT
  • member_id — BIGINT
  • provider — VARCHAR(20)