ERDPROJECT

Tables (12)

BOARD

  • board_no — bigint — Primary key — NOT NULL
  • board_tilte — varchar
  • board_content — varchar
  • board_write — varchar
  • board_regdate — date
  • board_cnt — int

BOARD_COMMENT

  • comment_no — bigint — Primary key — NOT NULL
  • comment_content — varchar — NOT NULL
  • comment_write — varchar
  • comment_regdate — date

BOARD_FILE

  • board_file_no — bigint — Primary key — NOT NULL
  • board_file_name — varchar
  • board_file_path — varchar
  • board_file_origin — varchar
  • board_file_cate — varchar

BUSINESS

  • business_no — bigint — Primary key — NOT NULL
  • business_cate — varchar — NOT NULL
  • business_reason — varchar
  • business_period — date
  • business_loacation — varchar

CAREER

  • career_no — VARCHAR(255) — Primary key — NOT NULL
  • career_type — varchar
  • career_name — varchar
  • career_period — date
  • career_publish — varchar

CONTRACT

  • contract_no — bigint — Primary key — NOT NULL
  • contract_sal — int
  • contract_period — varchar
  • contract_work_time — varchar
  • contract_type — char
  • contract_bonus — int

HR_INFO

  • hr_no — bigint — Primary key — NOT NULL
  • hr_eno — varchar
  • hr_rank — varchar
  • hr_dept — varchar

IN_OUT

  • inout_no — bigint — Primary key — NOT NULL
  • inout_info — varchar
  • inout_in_status — char
  • inout_out_status — char
  • inout_leave_status — char

LEAVE

  • leave_no — VARCHAR(255) — Primary key — NOT NULL
  • leave_cate — varchar
  • leave_reason — varchar
  • leave_staus — char
  • leave_remain — int
  • leave_start — date
  • leave_end — date

USER

  • user_no — bigint — Primary key — NOT NULL
  • user_id — varchar
  • user_pw — varchar
  • user_name — varchar
  • user_address — varchar
  • user_email — varchar
  • user_tel — varchar
  • user_birth — date
  • user_gender — varchar

USER_FILE

  • u_image_no — bigint — Primary key — NOT NULL
  • u_image_name — varchar
  • u_image_path — varchar
  • u_image_origin — varchar
  • u_image_cate — varchar

WORK_TIME

  • work_no — VARCHAR(255) — Primary key — NOT NULL