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