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