high-level-design

Tables (19)

alarm (Untitled12)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
  • alarm_text (Field) — text
  • third_party_app (Field2) — varchar

applicant_tracking (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • job_posting_id (Key2) — int — Foreign key → job_posting.id — NOT NULL
  • resume_tracking_id (Key3) — int — Foreign key → resume_tracking.id — NOT NULL
  • status (Field) — varchar
  • applied_date (Field2) — date

application_info (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • applicant_name, email (Key2) — Primary key — NOT NULL
  • applicant_name (Field) — varchar
  • email (Field2) — varchar
  • phone (Field3) — varchar
  • address (Field4) — varchar
  • birth_date (Field5) — date

applied_companies (Untitled9)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
  • applicant_info_id (Key3) — int — Foreign key → application_info.id — NOT NULL

career (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
  • company_name (Field) — varchar
  • position (Field2) — varchar
  • start_date (Field3) — date
  • end_date (Field4) — date
  • work_description (Field5) — text

com_user_authority (Untitled14)

  • id (Key) — int — Primary key — NOT NULL
  • hr_managers_id (Key2) — int — Foreign key → hr_managers.id — NOT NULL
  • authority_name (Field) — varchar

comp_info (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Key2) — Primary key — NOT NULL
  • com_user_id (bigint) — varchar
  • business_number (Field) — varchar
  • address (Field2) — varchar
  • email (Field3) — varchar

comp_prof (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key3) — int — Foreign key → comp_info.id — NOT NULL
  • logo (Field) — varchar
  • employee_count (Field2) — int
  • revenue (Field3) — bigint
  • business_item (Field4) — varchar
  • ceo_name (Field5) — varchar
  • address (Field6) — varchar

education (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
  • school_name (Field) — varchar
  • major (Field2) — varchar
  • entrance_year (Field3) — year
  • graduation_year (Field4) — year
  • degree (Field5) — varchar

hr_managers (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
  • position (Field) — varchar

job_posting (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key22) — int — Foreign key → comp_info.email — NOT NULL
  • job_title (Field) — varchar
  • description (Field2) — text
  • post_date (Field3) — date

job_posting_skill (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • job_posting_id (Key2) — int — Foreign key → job_posting.id — NOT NULL
  • skill_name (Field) — varchar

manage_users (Untitled17)

  • id (Key3) — int — Primary key — NOT NULL
  • applicant_info_id (Key) — int — Foreign key → application_info.id — NOT NULL
  • status (Field) — varchar

menu (Untitled15)

  • id (Key) — int — Primary key — NOT NULL
  • com_user_id (Key2) — int — Foreign key → com_user_authority.id — NOT NULL
  • url (Field) — varchar
  • menu_name (Field2) — varchar

message (Untitled13)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
  • applicant_info_id (Key3) — int — Foreign key → application_info.id — NOT NULL
  • receiver (Field) — varchar

payment (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • comp_info_id (Key2) — int — Foreign key → comp_info.id — NOT NULL
  • payment_method (Field) — varchar
  • card_info (Field2) — varchar
  • paid_at (Field3) — date

payment/sales (Untitled16)

  • id (Key) — int — Primary key — NOT NULL
  • payment_id (Key2) — int — Foreign key → payment.id — NOT NULL
  • net_sales (Field) — decimal
  • fees (Field2) — decimal

resume_tracking (CopyOfUntitled8)

  • id (Key) — int — Primary key — NOT NULL
  • applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
  • resume_text (Field) — text
  • submission_date (Field5) — date

skill (CopyOfUntitled7)

  • id (Key) — int — Primary key — NOT NULL
  • applicant_id (Key2) — int — Foreign key → application_info.id — NOT NULL
  • career_id (Key3) — int — Foreign key → career.id — NOT NULL
  • skill_name (Field) — varchar
  • proficiency (Field2) — varchar