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