Calfit

Tables (37)

announcement_boards

  • id — BIGINT — Primary key — NOT NULL — id
  • is_pinned — BIT — NOT NULL — is_pinned
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • title — VARCHAR(100) — NOT NULL — title
  • content — VARCHAR(2000) — NOT NULL — content
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

applicants

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • email — VARCHAR(255) — NOT NULL — email
  • name — VARCHAR(255) — NOT NULL — name
  • password — VARCHAR(255) — NOT NULL — password
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

application_files

  • id — BIGINT — Primary key — NOT NULL — id
  • applicant_id — BIGINT — NOT NULL — applicant_id
  • application_id — BIGINT — NOT NULL — application_id
  • created_at — DATETIME(6) — created_at
  • size_bytes — BIGINT — size_bytes
  • updated_at — DATETIME(6) — updated_at
  • content_type — VARCHAR(255) — NOT NULL — content_type
  • field_key — VARCHAR(255) — NOT NULL — field_key
  • object_key — VARCHAR(255) — NOT NULL — object_key
  • original_filename — VARCHAR(255) — NOT NULL — original_filename
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status
  • upload_status — ENUM('ACTIVE', 'PENDING') — NOT NULL — upload_status

application_process_histories

  • id — BIGINT — Primary key — NOT NULL — id
  • actor_id — BIGINT — NOT NULL — actor_id
  • application_id — BIGINT — NOT NULL — application_id
  • created_at — DATETIME(6) — created_at
  • from_recruitment_process_id — BIGINT — from_recruitment_process_id
  • to_recruitment_process_id — BIGINT — NOT NULL — to_recruitment_process_id
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

application_templates

  • id — BIGINT — Primary key — NOT NULL — id
  • is_default — BIT — is_default
  • birth_date — DATETIME(6) — NOT NULL — birth_date
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • phone — VARCHAR(20) — NOT NULL — phone
  • email — VARCHAR(50) — NOT NULL — email
  • name — VARCHAR(50) — NOT NULL — name
  • form_fields — JSON — NOT NULL — form_fields
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • gender — ENUM('FEMALE', 'MALE') — NOT NULL — gender
  • status — ENUM('ACTIVE', 'DELETED') — status

applications

  • id — BIGINT — Primary key — NOT NULL — id
  • applicant_id — BIGINT — NOT NULL — applicant_id
  • birth_date — DATETIME(6) — NOT NULL — birth_date
  • created_at — DATETIME(6) — created_at
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • recruitment_process_id — BIGINT — NOT NULL — recruitment_process_id
  • template_id — BIGINT — NOT NULL — template_id
  • updated_at — DATETIME(6) — updated_at
  • phone — VARCHAR(20) — NOT NULL — phone
  • email — VARCHAR(50) — NOT NULL — email
  • name — VARCHAR(50) — NOT NULL — name
  • form_fields — JSON — NOT NULL — form_fields
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • gender — ENUM('FEMALE', 'MALE') — NOT NULL — gender
  • status — ENUM('ACTIVE', 'DELETED') — status

automation_events

  • id — BIGINT — Primary key — NOT NULL — id
  • application_id — BIGINT — NOT NULL — application_id
  • created_at — DATETIME(6) — created_at
  • rule_id — BIGINT — NOT NULL — rule_id
  • updated_at — DATETIME(6) — updated_at
  • error_message — VARCHAR(1000) — error_message
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • action_type — ENUM('EMAIL', 'SLACK') — NOT NULL — action_type
  • event_status — ENUM('FAILED', 'PENDING', 'SUCCESS') — NOT NULL — event_status
  • status — ENUM('ACTIVE', 'DELETED') — status

automation_rules

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • recruitment_process_id — BIGINT — NOT NULL — recruitment_process_id
  • updated_at — DATETIME(6) — updated_at
  • payload — JSON — payload
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • action_type — ENUM('EMAIL', 'SLACK') — NOT NULL — action_type
  • status — ENUM('ACTIVE', 'DELETED') — status
  • trigger_type — ENUM('ON_ENTER') — NOT NULL — trigger_type

billing_keys

  • id — BIGINT — Primary key — NOT NULL — id
  • active — BIT — NOT NULL — active
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • billing_key — VARCHAR(255) — NOT NULL — billing_key
  • card_company — VARCHAR(255) — card_company
  • card_number — VARCHAR(255) — card_number
  • card_type — VARCHAR(255) — card_type
  • customer_key — VARCHAR(255) — NOT NULL — customer_key
  • owner_type — VARCHAR(255) — owner_type
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • status — ENUM('ACTIVE', 'DELETED') — status

costs

  • id — BIGINT — Primary key — NOT NULL — id
  • cost_month — INT — NOT NULL — cost_month
  • cost_year — INT — NOT NULL — cost_year
  • amount — BIGINT — NOT NULL — amount
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • memo — VARCHAR(255) — memo
  • name — VARCHAR(255) — NOT NULL — name
  • category — ENUM('INFRASTRUCTURE', 'LABOR', 'MARKETING', 'OTHER') — NOT NULL — category
  • status — ENUM('ACTIVE', 'DELETED') — status

email_verification_tokens

  • id — BIGINT — Primary key — NOT NULL — id
  • verified — BIT — NOT NULL — verified
  • expires_at — DATETIME(6) — NOT NULL — expires_at
  • token — VARCHAR(255) — NOT NULL — token
  • user_email — VARCHAR(255) — NOT NULL — user_email

external_calendars

  • id — BIGINT — Primary key — NOT NULL — id
  • is_sync_enabled — BIT — NOT NULL — is_sync_enabled
  • channel_expires_at — DATETIME(6) — channel_expires_at
  • created_at — DATETIME(6) — created_at
  • token_expires_at — DATETIME(6) — NOT NULL — token_expires_at
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • access_token — TEXT — NOT NULL — access_token
  • calendar_id — VARCHAR(255) — NOT NULL — calendar_id
  • channel_id — VARCHAR(255) — channel_id
  • channel_resource_id — VARCHAR(255) — channel_resource_id
  • refresh_token — TEXT — NOT NULL — refresh_token
  • sync_token — TEXT — sync_token
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

external_event

  • id — BIGINT — Primary key — NOT NULL — id
  • end_time_tz — INT — NOT NULL — end_time_tz
  • is_all_day — BIT — NOT NULL — is_all_day
  • is_busy — BIT — NOT NULL — is_busy
  • start_time_tz — INT — NOT NULL — start_time_tz
  • created_at — DATETIME(6) — created_at
  • end_time — DATETIME(6) — NOT NULL — end_time
  • external_calendar_id — BIGINT — NOT NULL — external_calendar_id
  • start_time — DATETIME(6) — NOT NULL — start_time
  • updated_at — DATETIME(6) — updated_at
  • description — TEXT — description
  • google_event_id — VARCHAR(255) — NOT NULL — google_event_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • title — VARCHAR(255) — title
  • status — ENUM('ACTIVE', 'DELETED') — status

interview_responses

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • interview_schedule_id — BIGINT — NOT NULL — interview_schedule_id
  • responded_at — DATETIME(6) — NOT NULL — responded_at
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • decline_reason — VARCHAR(255) — NOT NULL — decline_reason
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • response_status — ENUM('ACCEPTED', 'DECLINED') — NOT NULL — response_status
  • status — ENUM('ACTIVE', 'DELETED') — status

interview_schedule_applicants

  • id — BIGINT — Primary key — NOT NULL — id
  • applicant_id — BIGINT — NOT NULL — applicant_id
  • created_at — DATETIME(6) — created_at
  • interview_schedule_id — BIGINT — NOT NULL — interview_schedule_id
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

interview_schedule_histories

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • created_by — BIGINT — NOT NULL — created_by
  • interview_schedule_id — BIGINT — NOT NULL — interview_schedule_id
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • event_data — JSON — event_data
  • event_type — ENUM('APPLICANT_ASSIGNED', 'APPLICANT_REMOVED', 'CREATED', 'INTERVIEWER_ACCEPTED', 'INTERVIEWER_ASSIGNED', 'INTERVIEWER_DECLINED', 'INTERVIEWER_REMOVED', 'RESCHEDULED', 'STATUS_CHANGED') — NOT NULL — event_type
  • status — ENUM('ACTIVE', 'DELETED') — status

interview_schedule_interviewers

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • interview_schedule_id — BIGINT — NOT NULL — interview_schedule_id
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

interview_schedules

  • id — BIGINT — Primary key — NOT NULL — id
  • duration_minutes — INT — NOT NULL — duration_minutes
  • created_at — DATETIME(6) — created_at
  • meeting_room_id — BIGINT — NOT NULL — meeting_room_id
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • recruitment_stage_id — BIGINT — recruitment_stage_id
  • scheduled_at — DATETIME(6) — NOT NULL — scheduled_at
  • updated_at — DATETIME(6) — updated_at
  • memo — VARCHAR(255) — NOT NULL — memo
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • interview_status — ENUM('CANCELLED', 'COMPLETED', 'CONFIRMED', 'PENDING') — NOT NULL — interview_status
  • status — ENUM('ACTIVE', 'DELETED') — status

invoices

  • id — BIGINT — Primary key — NOT NULL — id
  • billing_month — INT — NOT NULL — billing_month
  • billing_year — INT — NOT NULL — billing_year
  • issued_at — DATE — NOT NULL — issued_at
  • paid_at — DATE — paid_at
  • amount — BIGINT — NOT NULL — amount
  • created_at — DATETIME(6) — created_at
  • subscription_id — BIGINT — NOT NULL — subscription_id
  • updated_at — DATETIME(6) — updated_at
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • invoice_status — ENUM('OVERDUE', 'PAID', 'UNPAID') — NOT NULL — invoice_status
  • plan_type — ENUM('BUSINESS', 'ENTERPRISE') — NOT NULL — plan_type
  • status — ENUM('ACTIVE', 'DELETED') — status

meeting_room_histories

  • id — BIGINT — Primary key — NOT NULL — id
  • actor_id — BIGINT — NOT NULL — actor_id
  • created_at — DATETIME(6) — created_at
  • meeting_room_id — BIGINT — NOT NULL — meeting_room_id
  • meeting_room_resevation_id — BIGINT — meeting_room_resevation_id
  • occurred_at — DATETIME(6) — NOT NULL — occurred_at
  • updated_at — DATETIME(6) — updated_at
  • detail_json — JSON — detail_json
  • reason — VARCHAR(255) — reason
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • action_type — ENUM('CANCELED', 'CHANGED_ROOM', 'CREATED_ROOM', 'DELETED_ROOM', 'RESERVED', 'UPDATED_ROOM', 'UPDATED_TIME') — NOT NULL — action_type
  • status — ENUM('ACTIVE', 'DELETED') — status

meeting_room_reservations

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • end_datetime — DATETIME(6) — NOT NULL — end_datetime
  • interview_schedule_id — BIGINT — interview_schedule_id
  • meeting_room_id — BIGINT — NOT NULL — meeting_room_id
  • start_datetime — DATETIME(6) — NOT NULL — start_datetime
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • reservation_status — ENUM('ACTIVE', 'DELETED', 'EXPIRED', 'RESERVED') — NOT NULL — reservation_status
  • status — ENUM('ACTIVE', 'DELETED') — status

meeting_rooms

  • id — BIGINT — Primary key — NOT NULL — id
  • capacity — INT — NOT NULL — capacity
  • location — INT — NOT NULL — location
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • color — VARCHAR(20) — color
  • description — VARCHAR(1000) — description
  • facilities — TEXT — NOT NULL — facilities
  • name — VARCHAR(255) — NOT NULL — name
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

notifications

  • id — BIGINT — Primary key — NOT NULL — id
  • is_read — BIT — NOT NULL — is_read
  • created_at — DATETIME(6) — created_at
  • read_at — DATETIME(6) — read_at
  • recipient_user_id — BIGINT — NOT NULL — recipient_user_id
  • target_id — BIGINT — target_id
  • updated_at — DATETIME(6) — updated_at
  • title — VARCHAR(120) — NOT NULL — title
  • content — VARCHAR(1000) — NOT NULL — content
  • action_url — VARCHAR(255) — action_url
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • notification_type — ENUM('ANNOUNCEMENT_CREATED', 'APPLICATION_PROCESS_CHANGED', 'INTERVIEW_CANCELLED', 'INTERVIEW_REQUESTED', 'INTERVIEW_UPDATED', 'MEETING_ROOM_RESERVED', 'SCHEDULE_CANCELLED', 'SCHEDULE_INVITED', 'SCHEDULE_UPDATED') — NOT NULL — notification_type
  • status — ENUM('ACTIVE', 'DELETED') — status
  • target_type — ENUM('ANNOUNCEMENT', 'APPLICATION', 'INTERVIEW_REQUEST', 'INTERVIEW_SCHEDULE', 'MEETING_ROOM_RESERVATION', 'SCHEDULE') — NOT NULL — target_type

payments

  • id — BIGINT — Primary key — NOT NULL — id
  • retry_count — INT — NOT NULL — retry_count
  • amount — BIGINT — NOT NULL — amount
  • created_at — DATETIME(6) — created_at
  • invoice_id — BIGINT — invoice_id
  • next_retry_at — DATETIME(6) — next_retry_at
  • paid_at — DATETIME(6) — paid_at
  • subscription_id — BIGINT — subscription_id
  • updated_at — DATETIME(6) — updated_at
  • billing_key — VARCHAR(255) — billing_key
  • fail_reason — VARCHAR(255) — fail_reason
  • order_id — VARCHAR(255) — NOT NULL — order_id
  • payment_key — VARCHAR(255) — payment_key
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • payment_status — ENUM('CANCELLED', 'FAILED', 'RETRY', 'SUCCESS') — NOT NULL — payment_status
  • status — ENUM('ACTIVE', 'DELETED') — status

recruitment_histories

  • id — BIGINT — Primary key — NOT NULL — id
  • actor_id — BIGINT — NOT NULL — actor_id
  • created_at — DATETIME(6) — created_at
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • stage_id — BIGINT — stage_id
  • updated_at — DATETIME(6) — updated_at
  • reason — VARCHAR(255) — reason
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • action_type — ENUM('INTERVIEWER_ADDED', 'INTERVIEWER_REMOVED', 'RECRUITMENT_CLOSED', 'RECRUITMENT_CREATED', 'RECRUITMENT_DELETE', 'RECRUITMENT_INFO_UPDATED', 'RECRUITMENT_OPENED', 'STAGE_CREATED', 'STAGE_DELETED', 'STAGE_REORDERED', 'STAGE_UPDATED') — NOT NULL — action_type
  • change_log — JSON — change_log
  • status — ENUM('ACTIVE', 'DELETED') — status

recruitment_interviewers

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

recruitment_reference_teams

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • group_id — BIGINT — NOT NULL — group_id
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

recruitment_stages

  • id — BIGINT — Primary key — NOT NULL — id
  • stage_step — INT — NOT NULL — stage_step
  • created_at — DATETIME(6) — created_at
  • recruitment_id — BIGINT — NOT NULL — recruitment_id
  • updated_at — DATETIME(6) — updated_at
  • stage_name — VARCHAR(255) — NOT NULL — stage_name
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • stage_type — ENUM('DOCUMENT', 'FAIL', 'INTERVIEW', 'OFFER', 'PASS', 'TEST') — NOT NULL — stage_type
  • status — ENUM('ACTIVE', 'DELETED') — status

recruitments

  • id — BIGINT — Primary key — NOT NULL — id
  • max_experience_years — INT — max_experience_years
  • min_experience_years — INT — min_experience_years
  • target_count — INT — NOT NULL — target_count
  • application_template_id — BIGINT — NOT NULL — application_template_id
  • created_at — DATETIME(6) — created_at
  • creator_id — BIGINT — NOT NULL — creator_id
  • end_date — DATETIME(6) — end_date
  • lead_group_id — BIGINT — NOT NULL — lead_group_id
  • start_date — DATETIME(6) — start_date
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • title — VARCHAR(255) — NOT NULL — title
  • career_type — ENUM('EXPERIENCED', 'IRRELEVANT', 'NEW') — NOT NULL — career_type
  • contents — TINYTEXT — contents
  • recruitment_status — ENUM('CLOSED', 'DRAFT', 'OPEN') — NOT NULL — recruitment_status
  • status — ENUM('ACTIVE', 'DELETED') — status

schedule

  • id — BIGINT — Primary key — NOT NULL — id
  • is_all_day — BIT — NOT NULL — is_all_day
  • is_busy — BIT — is_busy
  • created_at — DATETIME(6) — created_at
  • end_time — DATETIME(6) — NOT NULL — end_time
  • interview_schedule_id — BIGINT — interview_schedule_id
  • reservation_id — BIGINT — reservation_id
  • room_id — BIGINT — room_id
  • start_time — DATETIME(6) — NOT NULL — start_time
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • description — TEXT — description
  • google_event_id — VARCHAR(255) — google_event_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • title — VARCHAR(255) — NOT NULL — title
  • schedule_type — ENUM('BUSINESS', 'INTERVIEW', 'MEETING', 'OTHERS', 'VACATION') — NOT NULL — schedule_type
  • status — ENUM('ACTIVE', 'DELETED') — status

schedule_attendees

  • id — BIGINT — Primary key — NOT NULL — id
  • attendee_id — BIGINT — NOT NULL — attendee_id
  • created_at — DATETIME(6) — created_at
  • schedule_id — BIGINT — NOT NULL — schedule_id
  • updated_at — DATETIME(6) — updated_at
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

subscriptions

  • id — BIGINT — Primary key — NOT NULL — id
  • end_date — DATE — end_date
  • start_date — DATE — NOT NULL — start_date
  • cancelled_at — DATETIME(6) — cancelled_at
  • created_at — DATETIME(6) — created_at
  • monthly_amount — BIGINT — NOT NULL — monthly_amount
  • updated_at — DATETIME(6) — updated_at
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • plan_type — ENUM('BUSINESS', 'ENTERPRISE') — NOT NULL — plan_type
  • status — ENUM('ACTIVE', 'DELETED') — status
  • subscription_status — ENUM('ACTIVE', 'CANCELLED', 'SUSPENDED', 'TRIAL') — NOT NULL — subscription_status

user_groups

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • color — VARCHAR(255) — color
  • name — VARCHAR(255) — NOT NULL — name
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • status — ENUM('ACTIVE', 'DELETED') — status

users

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • name — VARCHAR(50) — NOT NULL — name
  • email — VARCHAR(255) — NOT NULL — email
  • password — VARCHAR(255) — NOT NULL — password
  • role — ENUM('ADMIN', 'MEMBER') — NOT NULL — role
  • status — ENUM('ACTIVE', 'DELETED') — status

workspace_invitations

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • expires_at — DATETIME(6) — NOT NULL — expires_at
  • invited_by — BIGINT — NOT NULL — invited_by
  • updated_at — DATETIME(6) — updated_at
  • email — VARCHAR(255) — NOT NULL — email
  • token — VARCHAR(255) — NOT NULL — token
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • invitation_status — ENUM('ACCEPTED', 'EXPIRED', 'PENDING') — NOT NULL — invitation_status
  • member_type — ENUM('HR', 'INTERVIEWER') — NOT NULL — member_type
  • status — ENUM('ACTIVE', 'DELETED') — status

workspace_members

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • group_id — BIGINT — group_id
  • updated_at — DATETIME(6) — updated_at
  • user_id — BIGINT — NOT NULL — user_id
  • tenant_id — VARCHAR(255) — NOT NULL — tenant_id
  • member_type — ENUM('HR', 'INTERVIEWER') — NOT NULL — member_type
  • status — ENUM('ACTIVE', 'DELETED') — status

workspaces

  • id — BIGINT — Primary key — NOT NULL — id
  • created_at — DATETIME(6) — created_at
  • updated_at — DATETIME(6) — updated_at
  • contact_phone — VARCHAR(255) — contact_phone
  • employee_scale — VARCHAR(255) — employee_scale
  • name — VARCHAR(255) — NOT NULL — name
  • workspace_id — VARCHAR(255) — NOT NULL — workspace_id
  • status — ENUM('ACTIVE', 'DELETED') — status