Modle
Tables (16)
application
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- model_id — BIGINT — Foreign key → model.id — NOT NULL
- cover_letter — TEXT
- status — ENUM( 'APPLIED', 'CONTACTED', 'CONTRACT_SENT', 'SHOOTING', 'SHOOTING_CANCELLED', 'ON_HOLD', 'COMPLETED', 'REJECTED', 'APPLICATION_CANCELLED' ) — NOT NULL
- withdraw_reason — TEXT
- rejection_reason — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
bookmark
- id — BIGINT — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → model.id — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- created_at — DATETIME — NOT NULL
client
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- client_role — BOOLEAN — NOT NULL — 0: 개인, 1: 단체
- approval_status — ENUM('PENDING', 'APPROVED','REJECTED')) — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- company_number — VARCHAR(20)
- introduction — TEXT
- logo_url — VARCHAR(500)
- avg_rating — DECIMAL(3, 2) — NOT NULL
- review_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- reject_at — DATETIME
client_tag
- id — BIGINT — Primary key — NOT NULL
- client_id — BIGINT — Foreign key → client.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
contract
- id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → application.id — NOT NULL
- contract_type — ENUM('TEMPLATE','FILE') — NOT NULL
- shoot_date — DATE
- shoot_time — TIME
- location — VARCHAR(200)
- payment — DECIMAL(10,2)
- pay_type — ENUM('CASH','SERVICE')
- usage_scope — VARCHAR(500)
- memo — TEXT
- pdf_url — VARCHAR(500)
- signed_pdf_url — VARCHAR(500)
- status — ENUM( 'DRAFT', 'NOTIFIED', 'VIEWED', 'AGREED', 'REJECTED', 'CONFIRMED', 'CANCELLED' ) — NOT NULL
- client_agreed — TINYINT(1) — NOT NULL
- model_agreed — TINYINT(1) — NOT NULL
- client_agreed_at — DATETIME
- model_agreed_at — DATETIME
- client_ip — VARCHAR(45)
- model_ip — VARCHAR(45)
- viewed_at — DATETIME
- notified_at — DATETIME
- confirmed_at — DATETIME
- created_at — DATETIME — NOT NULL
message
- id — BIGINT — Primary key — NOT NULL
- sender_id — BIGINT — Foreign key → user.id — NOT NULL
- receiver_id — BIGINT — Foreign key → user.id — NOT NULL
- application_id — BIGINT — Foreign key → application.id
- post_id — BIGINT — Foreign key → post.id
- parent_message_id — BIGINT — Foreign key → message.id
- content — TEXT — NOT NULL
- sender_type — ENUM('USER','SYSTEM') — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- read_at — DATETIME
- created_at — DATETIME — NOT NULL
model
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- age — INT
- sex — VARCHAR(2)
- height — INT
- weight — INT
- introduction — TEXT
- profile_image_url — VARCHAR(500)
- avg_rating — DECIMAL(3,2) — NOT NULL
- review_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
model_category
- id — BIGINT — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → model.id — NOT NULL
- category — ENUM('HAIR','MAKEUP','HAND','FITTING','CLOTHING','ETC') — NOT NULL
model_tag
- id — BIGINT — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → model.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
portfolio
- id — BIGINT — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → model.id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_type — ENUM('IMAGE','VIDEO') — NOT NULL
- thumbnail_url — VARCHAR(500)
- concept — ENUM('CASUAL','BEAUTY','FORMAL','STREET','OUTDOOR','ETC') — NOT NULL
- sort_order — INT — NOT NULL
- is_deleted — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
post
- id — BIGINT — Primary key — NOT NULL
- client_id — BIGINT — Foreign key → client.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- region — VARCHAR(50) — NOT NULL
- category — ENUM('HAIR','MAKEUP','CLOTHING','FOOD','PRODUCT','ETC') — NOT NULL
- payment — DECIMAL(10,2)
- pay_type — ENUM('CASH','SERVICE','FREE') — NOT NULL
- shoot_date — DATE
- required_count — INT — NOT NULL
- current_required_count — INT — NOT NULL
- status — ENUM('OPEN','SHOOTING','COMPLETED','CANCELLED','ON_HOLD','CLOSED') — NOT NULL
- expired_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
post_image
- id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
report
- id — BIGINT — Primary key — NOT NULL
- reporter_id — BIGINT — Foreign key → user.id — NOT NULL
- target_id — BIGINT — NOT NULL
- target_type — ENUM('USER','POST') — NOT NULL
- reason — ENUM('NOSHOW','FRAUD','ABUSE','ETC') — NOT NULL
- detail — TEXT
- status — ENUM('PENDING','REVIEWED','DISMISSED','PENALIZED') — NOT NULL
- created_at — DATETIME — NOT NULL
- reviewed_at — DATETIME
review
- id — BIGINT — Primary key — NOT NULL
- contract_id — BIGINT — Foreign key → contract.id — NOT NULL
- reviewer_id — BIGINT — Foreign key → user.id — NOT NULL
- reviewee_id — BIGINT — Foreign key → user.id — NOT NULL
- reviewer_role — ENUM('CLIENT','MODEL') — NOT NULL
- rating — FLOAT — NOT NULL
- content — TEXT
- is_public — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
tag
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — ENUM('MODEL','CLIENT') — NOT NULL
- is_default — TINYINT(1) — NOT NULL
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- role — ENUM('CLIENT','MODEL','ADMIN') — NOT NULL
- region — VARCHAR(50)
- provider — ENUM('LOCAL','GOOGLE','KAKAO') — NOT NULL
- provider_id — VARCHAR(100)
- is_active — TINYINT(1) — NOT NULL
- warning_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL