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