text2

Tables (20)

attachment

  • attach_id — BIGINT
  • ref_type — VARCHAR(20) — NOT NULL
  • ref_id — BIGINT — Foreign key → bizinfo.bizinfo_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • origin_name — VARCHAR(255)
  • is_thumbnail — BOOLEAN
  • created_at — DATETIME

bids

  • bid_id — BIGINT
  • request_id — BIGINT — Foreign key → request.request_id — NOT NULL
  • business_id — BIGINT — Foreign key → business.business_id — NOT NULL
  • price — BIGINT — NOT NULL
  • duration_days — BIGINT — NOT NULL
  • 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) — NOT NULL
  • biz_description — TEXT — NOT NULL
  • dimension — VARCHAR(100)
  • location — VARCHAR(255)
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • business_id — BIGINT — Foreign key → business.business_id — NOT NULL

business

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

business_settlement

  • id — BIGINT
  • business_id — BIGINT — Foreign key → business.business_id — NOT NULL
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • sales_amount — BIGINT — NOT NULL
  • commission_amount — BIGINT — NOT NULL
  • settlement_amount — BIGINT — NOT NULL
  • settlement_status — VARCHAR(20)
  • created_at — DATETIME

career

  • career_id — BIGINT
  • bizinfo_id — BIGINT — Foreign key → bizinfo.bizinfo_id — NOT NULL
  • work_description — TEXT — NOT NULL

cart

  • cart_id — BIGINT
  • customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
  • created_at — DATETIME

cart_items

  • cart_item_id — BIGINT
  • kit_id — BIGINT — Foreign key → kit.kit_id — NOT NULL
  • cart_id — BIGINT — Foreign key → cart.cart_id — NOT NULL
  • quantity — BIGINT — NOT NULL
  • created_at — DATETIME

category

  • category_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

chat_function

  • room_id — BIGINT — Foreign key → chat_room.room_id
  • business_id — BIGINT — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • last_read_at — DATETIME
  • is_pinned — BOOLEAN

chat_message

  • message_id — BIGINT
  • room_id — BIGINT — Foreign key → chat_room.room_id — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • message_type — VARCHAR(20)
  • content — TEXT
  • is_read — BOOLEAN
  • send_at — DATETIME

chat_room

  • room_id — BIGINT
  • bid_id — BIGINT — Foreign key → bids.bid_id — NOT NULL
  • customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
  • business_id — BIGINT — Foreign key → business.business_id — NOT NULL
  • created_at — DATETIME

customer

  • customer_id — BIGINT
  • login_id — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255)
  • phone_number — VARCHAR(20) — NOT NULL
  • 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 — Foreign key → business.business_id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • manufacturer — VARCHAR(255)
  • price — BIGINT — NOT NULL
  • stock — BIGINT
  • created_at — DATETIME

notice

  • notice_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

order_items

  • order_item_id — BIGINT
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • kit_id — BIGINT — Foreign key → kit.kit_id
  • price — BIGINT — NOT NULL
  • quantity — BIGINT — NOT NULL

orders

  • order_id — BIGINT
  • order_no — VARCHAR(50) — NOT NULL
  • customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
  • business_id — BIGINT — Foreign key → business.business_id
  • total_amount — BIGINT — NOT NULL
  • payment_status — VARCHAR(20)
  • payment_method — VARCHAR(20)
  • created_at — DATETIME
  • duedate — DATETIME

request

  • request_id — BIGINT
  • customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
  • category_id — BIGINT — Foreign key → category.category_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • hope_price — BIGINT — NOT NULL
  • hope_period — BIGINT — NOT NULL
  • status — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

review

  • review_id — BIGINT — NOT NULL
  • order_id — BIGINT — NOT NULL — 주문 번호
  • customer_id — BIGINT — NOT NULL — 리뷰 작성 고객
  • business_id — BIGINT — NOT NULL — 리뷰 대상 업체
  • start_date — DATE — NOT NULL — 작업 시작일
  • end_date — DATE — NOT NULL — 작업 완료일
  • content — TEXT — NOT NULL — 리뷰 내용
  • image1 — VARCHAR(500) — 리뷰 이미지
  • is_hidden — BOOLEAN — 업체 숨김 처리 여부

social_login

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