기초
테이블 (12)
BOARD
- board_no — bigint — 기본 키 — NOT NULL
- board_tilte — varchar
- board_content — varchar
- board_write — varchar
- board_regdate — date
- board_cnt — int
BOARD_COMMENT
- comment_no — bigint — 기본 키 — NOT NULL
- comment_content — varchar — NOT NULL
- comment_write — varchar
- comment_regdate — date
BOARD_FILE
- board_file_no — bigint — 기본 키 — NOT NULL
- board_file_name — varchar
- board_file_path — varchar
- board_file_origin — varchar
- board_file_cate — varchar
BUSINESS
- business_no — bigint — 기본 키 — NOT NULL
- business_cate — varchar — NOT NULL
- business_reason — varchar
- business_period — date
- business_loacation — varchar
CAREER
- career_no — VARCHAR(255) — 기본 키 — NOT NULL
- career_type — varchar
- career_name — varchar
- career_period — date
- career_publish — varchar
CONTRACT
- contract_no — bigint — 기본 키 — NOT NULL
- contract_sal — int
- contract_period — varchar
- contract_work_time — varchar
- contract_type — char
- contract_bonus — int
HR_INFO
- hr_no — bigint — 기본 키 — NOT NULL
- hr_eno — varchar
- hr_rank — varchar
- hr_dept — varchar
IN_OUT
- inout_no — bigint — 기본 키 — NOT NULL
- inout_info — varchar
- inout_in_status — char
- inout_out_status — char
- inout_leave_status — char
LEAVE
- leave_no — VARCHAR(255) — 기본 키 — NOT NULL
- leave_cate — varchar
- leave_reason — varchar
- leave_remain — int
- leave_start — date
- leave_end — date
USER
- user_no — bigint — 기본 키 — 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 — 기본 키 — NOT NULL
- u_image_name — varchar
- u_image_path — varchar
- u_image_origin — varchar
- u_image_cate — varchar
WORK_TIME
- work_no — VARCHAR(255) — 기본 키 — NOT NULL