pr2

Tables (21)

ADMIN_AUDIT_LOG

  • id — BIGINT — NOT NULL
  • admin_id — BIGINT — Foreign key → ADMIN_USER.id — NOT NULL
  • action_type — ENUM('PROJECT_FEATURED','USER_SUSPENDED','DISPUTE_RESOLVED','REVIEW_HIDDEN','CONFIG_UPDATED','SKILL_PROMOTED','USER_ACTIVATED','PROJECT_HIDDEN') — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • before_value — JSON
  • after_value — JSON
  • ip_address — VARCHAR(45)
  • performed_at — TIMESTAMP — NOT NULL

ADMIN_USER

  • id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('SUPER_ADMIN','MANAGER','SUPPORT') — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • last_login_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

BANK_ACCOUNT

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • bank_name — VARCHAR(50) — NOT NULL
  • account_number — VARCHAR(512) — NOT NULL
  • verified — BOOLEAN — NOT NULL

BANK_VERIFICATION

  • id — BIGINT — NOT NULL
  • bank_account_id — BIGINT — Foreign key → BANK_ACCOUNT.id — NOT NULL
  • code — VARCHAR(10) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

CHAT_MESSAGE

  • id — BIGINT — NOT NULL
  • room_id — BIGINT — Foreign key → CHAT_ROOM.id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → USERS.id
  • content — TEXT
  • message_type — ENUM('TEXT','FILE','SYSTEM') — NOT NULL
  • sent_at — TIMESTAMP — NOT NULL

CHAT_ROOM

  • id — BIGINT — NOT NULL
  • user1_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • user2_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • room_type — ENUM('DIRECT_MESSAGE','CONTRACT_NEGOTIATION') — NOT NULL
  • contract_negotiation_id — BIGINT — Foreign key → CONTRACT_NEGOTIATION.id
  • created_at — TIMESTAMP — NOT NULL

CLIENT_PROFILE

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • client_type — ENUM('INDIVIDUAL','TEAM','SOLE_PROPRIETOR','CORPORATION') — NOT NULL
  • company_name — VARCHAR(200)
  • manager_name — VARCHAR(100)
  • manager_phone — VARCHAR(20)
  • manager_email — VARCHAR(255)
  • slogan — VARCHAR(200) — NOT NULL
  • subtitle — VARCHAR(200)
  • business_registration_number — VARCHAR(20)

CONTRACT

  • id — BIGINT — NOT NULL
  • negotiation_id — BIGINT — Foreign key → CONTRACT_NEGOTIATION.id — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.id — NOT NULL
  • client_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • partner_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • total_amount — INT — NOT NULL
  • status — ENUM('ACTIVE','COMPLETED','CANCELLED','DISPUTED') — NOT NULL
  • signed_at — TIMESTAMP — NOT NULL

CONTRACT_NEGOTIATION

  • id — BIGINT — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.id — NOT NULL
  • client_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • partner_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • application_id — BIGINT — Foreign key → PROJECT_APPLICATION.id
  • status — ENUM('IN_PROGRESS','COMPLETED','CANCELLED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

MILESTONE

  • id — BIGINT — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.id — NOT NULL
  • phase_no — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • due_date — DATE — NOT NULL
  • status — ENUM('PENDING','IN_PROGRESS','SUBMITTED','APPROVED','REJECTED') — NOT NULL

NOTIFICATION

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • notification_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

OAUTH_ACCOUNT

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • provider — ENUM('GOOGLE','KAKAO','GITHUB','FACEBOOK','NAVER') — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

PARTNER_PROFILE

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • partner_type — ENUM('INDIVIDUAL','TEAM','SOLE_PROPRIETOR','CORPORATION') — NOT NULL
  • preferred_project_type — ENUM('FREELANCE','CONTRACT_BASED')
  • work_available_hours — JSON
  • communication_channels — JSON
  • dev_level — ENUM('NEWBIE','JUNIOR','MIDDLE','SENIOR')
  • core_experience — ENUM('UNDER_1Y','1_3Y','3_5Y','5_10Y','OVER_10Y')
  • hourly_rate — INT
  • monthly_rate — INT
  • work_preference — ENUM('REMOTE','ONSITE','HYBRID')
  • github_url — VARCHAR(500)
  • blog_url — VARCHAR(500)
  • website_url — VARCHAR(500)
  • portfolio_pdf_url — VARCHAR(1000)
  • slogan — VARCHAR(200)
  • bio — TEXT
  • bio_pdf_url — VARCHAR(1000)
  • self_intro_visible — BOOLEAN — NOT NULL
  • skills_visible — BOOLEAN — NOT NULL
  • career_visible — BOOLEAN — NOT NULL

PARTNER_SKILL

  • id — BIGINT — NOT NULL
  • partner_profile_id — BIGINT — Foreign key → PARTNER_PROFILE.id — NOT NULL
  • skill_id — BIGINT — Foreign key → SKILL_MASTER.id
  • custom_skill_name — VARCHAR(100)
  • proficiency — ENUM('EXPERT','ADVANCED','INTERMEDIATE','BEGINNER') — NOT NULL
  • experience_range — ENUM('UNDER_1Y','1_3Y','3_5Y','OVER_5Y') — NOT NULL

PAYMENT

  • id — BIGINT — NOT NULL
  • contract_id — BIGINT — Foreign key → CONTRACT.id — NOT NULL
  • payment_type — ENUM('DEPOSIT','INTERIM','BALANCE') — NOT NULL
  • amount — INT — NOT NULL
  • status — ENUM('PENDING','HELD','RELEASED','REFUNDED','FROZEN') — NOT NULL
  • held_at — TIMESTAMP
  • released_at — TIMESTAMP

PORTFOLIO

  • id — BIGINT — NOT NULL
  • partner_profile_id — BIGINT — Foreign key → PARTNER_PROFILE.id — NOT NULL
  • source_project_id — BIGINT — Foreign key → PROJECT.id
  • title — VARCHAR(300) — NOT NULL
  • project_description — TEXT
  • is_visible — BOOLEAN — NOT NULL

PROJECT

  • id — BIGINT — NOT NULL
  • client_user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • project_type — ENUM('FREELANCE','CONTRACT_BASED') — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • work_scopes — JSON — NOT NULL
  • category — ENUM('WEB','ANDROID','IOS','PC','EMBEDDED','OTHER') — NOT NULL
  • progress_type — ENUM('NEW','MAINTENANCE') — NOT NULL
  • preparation_status — ENUM('IDEA','PLANNING_DOC','DETAILED_DESIGN','EXISTING_CODE') — NOT NULL
  • detailed_content — TEXT — NOT NULL
  • budget — INT — NOT NULL
  • expected_start_date — DATE
  • expected_duration_days — INT — NOT NULL
  • budget_negotiable — BOOLEAN — NOT NULL
  • status — ENUM('DRAFT','OPEN','IN_PROGRESS','COMPLETED','CANCELLED') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

PROJECT_APPLICATION

  • id — BIGINT — NOT NULL
  • project_id — BIGINT — Foreign key → PROJECT.id — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • cover_letter — TEXT — NOT NULL
  • status — ENUM('PENDING','ACCEPTED','REJECTED','CANCELLED','CONTRACTED') — NOT NULL
  • applied_at — TIMESTAMP — NOT NULL

SKILL_MASTER

  • id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_custom — BOOLEAN — NOT NULL

USERS

  • id — BIGINT — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • contact_email — VARCHAR(255) — NOT NULL
  • role — ENUM('PARTNER','CLIENT') — NOT NULL
  • gender — ENUM('MALE','FEMALE','OTHER')
  • birth_date — DATE
  • region — VARCHAR(100)
  • tax_email — VARCHAR(255)
  • fax_number — VARCHAR(20)
  • account_status — ENUM('ACTIVE','SUSPENDED','BANNED','WITHDRAWN') — NOT NULL
  • suspended_at — TIMESTAMP
  • suspended_reason — TEXT
  • suspended_by — BIGINT — Foreign key → ADMIN_USER.id
  • email_verified — BOOLEAN — NOT NULL
  • phone_verified — BOOLEAN — NOT NULL
  • identity_verified — BOOLEAN — NOT NULL
  • identity_verified_by — BIGINT — Foreign key → ADMIN_USER.id
  • created_at — TIMESTAMP — NOT NULL

USER_SESSION

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → USERS.id — NOT NULL
  • token — VARCHAR(1024) — NOT NULL
  • device_info — VARCHAR(255)
  • ip_address — VARCHAR(45)
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL