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