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)