erdproject

Tables (12)

BOARD

  • board_no — VARCHAR(255) — Primary key — NOT NULL
  • board_tilte — varchar
  • board_content — varchar
  • board_write — VARCHAR(255)
  • board_time — VARCHAR(255)
  • board_cnt — VARCHAR(255)

BOARD_COMMENT

  • comment_no — VARCHAR(255) — Primary key — NOT NULL
  • comment_content — bigint — NOT NULL
  • comment_write — varchar
  • comment_time — varchar

BOARD_FILE

  • board_file_no — VARCHAR(255) — Primary key — NOT NULL
  • board_file_name — varchar
  • board_file_path — varchar
  • board_file_origin — VARCHAR(255)
  • board_file_cate — VARCHAR(255)

BUSINESS

  • business_no — VARCHAR(255) — Primary key — NOT NULL
  • business_cate — bigint — NOT NULL
  • business_reason — varchar
  • business_date — varchar
  • business_loacation — VARCHAR(255)

CAREER

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

CONTRACT

  • contract_no — VARCHAR(255) — Primary key — NOT NULL
  • contract_sal — varchar
  • contract_period — varchar
  • contract_work_time — VARCHAR(255)
  • contract_type — VARCHAR(255)
  • contract_bonus — VARCHAR(255)

HR_INFO

  • hr_no — VARCHAR(255) — Primary key — NOT NULL
  • hr_eno — VARCHAR(255)
  • hr_rank — VARCHAR(255)
  • hr_dept — VARCHAR(255)

IN_OUT

  • inout_no — VARCHAR(255) — Primary key — NOT NULL
  • inout_info — varchar
  • inout_in_status — varchar
  • inout_out_status — VARCHAR(255)
  • inout_leave_status — VARCHAR(255)

LEAVE

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

USER

  • user_no — VARCHAR(255) — Primary key — NOT NULL
  • user_id — varchar
  • user_pw — VARCHAR(255)
  • user_name — VARCHAR(255)
  • user_address — VARCHAR(255)
  • user_email — VARCHAR(255)
  • user_tel — VARCHAR(255)
  • user_birth — VARCHAR(255)
  • user_gender — VARCHAR(255)

USER_FILE

  • u_image_no — VARCHAR(255) — Primary key — NOT NULL
  • u_image_name — varchar
  • u_image_path — varchar
  • u_image_origin — VARCHAR(255)
  • u_image_cate — VARCHAR(255)

WORK_TIME

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