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)