depart
Tables (13)
application_approvals
- id — BIGINT
- application_id — BIGINT — NOT NULL
- reviewer_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
applications
- id — BIGINT
- recruitment_id — BIGINT — NOT NULL
- profile_id — BIGINT — NOT NULL
- user_id — BIGINT
- status — application_status — NOT NULL
- message — TEXT
- submitted_at — TIMESTAMP
- profile_snapshot — JSONB
- portfolio_snapshot — JSONB
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
brands
- id — BIGINT
- brand_category — brand_category — NOT NULL
- name — VARCHAR(255) — NOT NULL
- homepage_url — TEXT
- instgram_url — TEXT
- logo_image_url — TEXT
- thumbnail_image_url — TEXT
- image_mood_urls — TEXT
- keywords — TEXT
- description — TEXT
- depart_description — TEXT
- service_description — TEXT
- target — TEXT
- key_color — VARCHAR(50)
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
local_accounts
- id — BIGINT
- user_id — BIGINT — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — TEXT — NOT NULL
- verified — BOOLEAN
- created_at — TIMESTAMP
plan_members
- id — BIGINT
- plan_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- application_id — BIGINT — NOT NULL
- position_type — position_type — NOT NULL
- status — member_status — NOT NULL
- joined_at — TIMESTAMP
- left_at — TIMESTAMP
- agreed_payment — DECIMAL(15,2)
- paid_amount — DECIMAL(15,2)
- note — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
plans
- id — BIGINT
- brand_id — BIGINT — NOT NULL
- plan_type — plan_type — NOT NULL
- start_at — TIMESTAMP
- sprint_start_at — TIMESTAMP
- end_at — TIMESTAMP
- status — plan_status — NOT NULL
- total_budget — DECIMAL(15,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
portfolio_files
- id — BIGINT
- usage — portfolio_file_usage — NOT NULL
- s3_key — TEXT — NOT NULL
- s3_bucket — TEXT — NOT NULL
- file_name — TEXT
- mime_type — VARCHAR(100)
- size_bytes — BIGINT
- thumbnail_url — TEXT
- reference_portfolio_id — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
portfolios
- id — BIGINT
- profile_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- is_default — BOOLEAN
- resume_file_id — BIGINT — NOT NULL
- portfolio_file_id — BIGINT
- portfolio_url — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
profiles
- id — BIGINT
- name — VARCHAR(100)
- phone — VARCHAR(30)
- contact_email — VARCHAR(255)
- birth — INT
- profile_image_url — TEXT
- intro — TEXT
- address — TEXT
- is_business — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
recruitments
- id — BIGINT
- brand_id — BIGINT — NOT NULL
- plan_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- position_type — position_type — NOT NULL
- recruit_count — INT
- deadline — TIMESTAMP
- status — recruitment_status — NOT NULL
- logo_image_url — TEXT
- thumbnail_image_url — TEXT
- reference_image_urls — TEXT
- monthly_fee — TEXT
- payment_guide — TEXT
- period_guide — TEXT
- work_content — TEXT
- etc_guide — TEXT
- notice — TEXT
- tips — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
refresh_tokens
- id — BIGINT
- local_account_id — BIGINT
- social_account_id — BIGINT
- token — TEXT — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
social_accounts
- id — BIGINT
- user_id — BIGINT — NOT NULL
- provider — social_provider — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
users
- id — BIGINT
- role — user_role — NOT NULL
- is_active — BOOLEAN — NOT NULL
- profile_id — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP