TEST2

Tables (19)

alarm

  • alarm_id — INT
  • company_id — INT — NOT NULL
  • receiver — VARCHAR(100)
  • type — VARCHAR(50)
  • content — VARCHAR(255)
  • send_date — DATETIME

applicant_info

  • applicant_id — INT
  • name — VARCHAR(50)
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • birth_date — DATE
  • phone — VARCHAR(20)
  • address — VARCHAR(200)

applicant_tracking

  • tracking_id — INT
  • job_post_id — INT — NOT NULL
  • applicant_id — INT — NOT NULL
  • apply_date — DATE
  • status — VARCHAR(50)

applied_companies

  • applied_id — INT
  • applicant_id — INT — NOT NULL
  • job_post_id — INT — NOT NULL
  • apply_date — DATE
  • status — VARCHAR(50)

career

  • career_id — INT
  • applicant_id — INT — NOT NULL
  • company — VARCHAR(100)
  • position — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • task — VARCHAR(100)

com_info

  • company_id — INT
  • biz_no — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(100) — NOT NULL

com_prof

  • company_id — INT
  • logo — VARCHAR(255)
  • employee_count — INT
  • sales — BIGINT
  • category — VARCHAR(100)
  • address — VARCHAR(200)
  • ceo_name — VARCHAR(50)

com_user_authority

  • authority_id — INT
  • company_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • role — VARCHAR(30)

education

  • edu_id — INT
  • applicant_id — INT — NOT NULL
  • school — VARCHAR(100)
  • major — VARCHAR(50)
  • start_year — INT
  • end_year — INT

hr_managers

  • manager_id — INT
  • company_id — INT — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(100)
  • role — VARCHAR(50)

job_posting

  • job_post_id — INT
  • company_id — INT — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT
  • start_date — DATE
  • end_date — DATE
  • salary — INT

job_posting_skill

  • skill_id — INT
  • job_post_id — INT — NOT NULL
  • skill_name — VARCHAR(50)

manage_users

  • user_id — INT
  • type — VARCHAR(30)
  • email — VARCHAR(100)
  • name — VARCHAR(50)

menu

  • menu_id — INT
  • menu_name — VARCHAR(50)
  • url — VARCHAR(200)
  • role — VARCHAR(30)

message

  • msg_id — INT
  • company_id — INT — NOT NULL
  • applicant_id — INT — NOT NULL
  • content — TEXT
  • send_date — DATETIME

payment

  • payment_id — INT
  • company_id — INT — NOT NULL
  • payment_date — DATE
  • amount — INT
  • method — VARCHAR(50)

payment_sales

  • sales_id — INT
  • company_id — INT — NOT NULL
  • amount — INT
  • date — DATE

resume_tracking

  • resume_id — INT
  • applicant_id — INT — NOT NULL
  • file_name — VARCHAR(255)
  • upload_date — DATE

skill

  • skill_id — INT
  • career_id — INT — NOT NULL
  • skill_name — VARCHAR(50)