hjerp

Tables (5)

Contract (계약)

  • contract_no (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — varchar(255) — Foreign key → user.user_id — NOT NULL
  • contract_name (Field10) — varchar(255)
  • contract_address (Field11) — varchar(1500)
  • gap_company (Field) — varchar(255)
  • el_company (Field2) — varchar(255)
  • contract_start (Field3) — date
  • contract_end (Field4) — date
  • created_at (Field5) — date
  • contract_field (Field6) — varchar(255)
  • contract_category (Field7) — varchar(255)
  • people_cnt (Field8) — int
  • benefit (Field9) — long

Employee (근무자)

  • employee_no (Key) — int — Primary key — NOT NULL
  • contract_no (Key2) — int — Foreign key → Contract.contract_no — NOT NULL
  • user_id (Key22) — varchar(255) — Foreign key → Contract.user_id — NOT NULL
  • name (Field) — varchar(255)
  • jumin_no (Field2) — varchar(255)
  • gender (Field3) — varchar(255)
  • phone (Field4) — varchar(255)
  • address (Field5) — varchar(1500)
  • employee_category (Field10) — varchar(255)
  • employee_class (Field11) — varchar(255)
  • hired_start (Field6) — date
  • hired_end (Field9) — date
  • hire_age (Field7) — int
  • now_age (Field8) — int

Employee_contract_name (근무지)

  • ecn_no (Key) — int — Primary key — NOT NULL
  • employee_no (Key2) — int — Foreign key → Employee.employee_no — NOT NULL
  • ecn_name (Field) — varchar(255)
  • ecn_address (Field2) — varchar(1500)
  • ecn_category (Field3) — varchar(255)
  • ecn_class (Field4) — varchar(255)
  • ecn_start (Field5) — date
  • ecn_end (Field6) — date

Image (이미지)

  • img_key (Key) — varchar(1500) — Primary key — NOT NULL
  • created_at (Field) — timestamp
  • url (Field2) — varchar(1500)

user (회원)

  • user_id (Key) — varchar(255) — Primary key — NOT NULL
  • password (Field) — varchar(1500)
  • name (Field2) — varchar(255)
  • company (Field3) — varchar(255)
  • role (Field4) — varchar(255)