(공개용)Linko 그룹웨어 프로젝트 ERD
테이블 (22)
alarm
- alarm_no — NUMBER — NOT NULL
- alarm_receive_no — NUMBER — NOT NULL
- alarm_sender_no — NUMBER — NOT NULL
- alarm_type — VARCHAR2(30)
- alarm_message — VARCHAR2(300)
- alarm_plan_no — NUMBER — NOT NULL
- alarm_read — CHAR(1)
- alarm_create_time — TIMESTAMP
attachment
- attachment_no — NUMBER — NOT NULL
- attachment_name — VARCHAR2(255)
- attachment_type — VARCHAR2(225)
- attachment_size — NUMBER
attendance_images
- attendance_reason_no — NUMBER — NOT NULL
- attachment_no — NUMBER — NOT NULL
attendance_log
- attendance_log_no — NUMBER — NOT NULL
- attendance_log_day — DATE
- attendance_log_in_time — TIMESTAMP — 회사에서 설정한 출근시간
- attendance_log_out_time — TIMESTAMP — 회사에서 설정한 퇴근시간
- attendance_work_time — TIMESTAMP
- member_no — NUMBER — NOT NULL
attendance_outing
- attendance_outing_no — NUMBER — NOT NULL
- attendance_outing_reason — VARCHAR2(300)
- attendance_outing_day — CHAR(10)
- attendance_outing_start — CHAR(8)
- attendance_outing_ernd — CHAR(8)
- member_no — NUNMBER
- member_no2 — NUMBER — NOT NULL
attendance_policy
- attendance_policy_no — NUMBER — NOT NULL
- attendance_policy_in_time — CHAR(8)
- attendance_policy_arrange — NUMBER
- attendance_policy_grace — NUMBER
- attendance_policy_lunch_time — NUMBER
- attendance_policy_dinner_time — NUMBER
- attendance_policy_type — VARCHAR2(12)
attendance_reason
- attendance_reason_no — NUMBER — NOT NULL
- attendance_reason_content — VARCHAR2(60)
- attendance_reason_start — CHAR(8)
- attendance_reason_end — CHAR(8)
- attendance_reason_day — CHAR(10)
- member_no — NUMBER
- member_no2 — NUMBER — NOT NULL
attendance_result
- attendance_result_no — NUMBER — NOT NULL
- attendance_result_in_time — TIMESTAMP
- attendance_result_out_time — TIMESTAMP
- attendance_result_late_minute — NUMBER
- attendance_result_ealry_leave — NUMBER
- attendance_result_work_time — NUMBER
- attendance_result_day — DATE
- member_no — NUMBER
- member_no2 — NUMBER — NOT NULL
holiday
- holiday_no — NUMBER — NOT NULL
- holiday_name — VARCHAR2(50)
- holiday_date — TIMESTAMP
- holiday_admin — CHAR(1)
member
- member_no — NUMBER — NOT NULL
- member_id — VARCHAR2(20)
- member_pw — VARCHAR2(16)
- member_name — VARCHAR2(10)
- member_resident_no — VARCHAR2(14)
- member_contact — CHAR(11)
- member_email — VARCHAR2(60)
- member_post — VARCHAR2(6)
- member_address1 — VARCHAR2(300)
- member_address2 — VARCHAR2(300)
- member_department — VARCHAR2(30)
- member_rank — VARCHAR2(10)
- member_bank — VARCHAR2(30)
- member_bank_no — VARCHAR2(28)
- member_state — CHAR(1)
- member_type — VARCHAR2(30)
- member_join — TIMESTAMP
member_document
- member_no — NUMBER — NOT NULL
- attachment_no — NUMBER — NOT NULL
- member_document_type — varchar2(30)
member_profile
- attachment_no — NUMBER — NOT NULL
- member_no — NUMBER — NOT NULL
notice
- notice_no — NUMBER — NOT NULL
- notice_type — VARCHAR2(30)
- notice_title — VARCHAR2(300)
- notice_content — VARCHAR2(3000)
- notice_write_date — TIMESTAMP
- notice_writer_no — NUMBER — NOT NULL
notice_editor_image
- notice_no — NUMBER — NOT NULL
- attachment_no — NUMBER — NOT NULL
notice_image
- notice_no — NUMBER — NOT NULL
- attachment_no — NUMBER — NOT NULL
plan
- plan_no — NUMBER — NOT NULL
- plan_sender_no — NUMBER — NOT NULL
- plan_status — VARCHAR2(20)
- plan_type — VARCHAR2(20)
- plan_title — VARCHAR2(300)
- plan_content — VARCHAR2(3000)
- plan_color — VARCHAR2(20)
- plan_start_time — TIMESTAMP
- plan_end_time — TIMESTAMP
- plan_is_all_day — CHAR(1)
- plan_create_time — TIMESTAMP
plan_receive
- plan_receive_no — NUMBER — NOT NULL
- plan_receive_receiver_no — NUMBER — NOT NULL
- plan_receive_is_writer — CHAR(1)
- plan_receive_is_accept — CHAR(1)
- plan_receive_status — VARCHAR2(20)
room
- room_no — NUMBER — NOT NULL
- room_title — VARCHAR2(90)
- room_profile_no — NUMBER
- room_owner — NUMBER — NOT NULL
room_chat
- room_chat_no — NUMBER — NOT NULL
- room_chat_origin — NUMBER — NOT NULL
- room_chat_sender — NUMBER — NOT NULL
- room_chat_type — VARCHAR2(6)
- room_chat_content — VARCHAR2(600)
- room_chat_time — TIMESTAMP
room_chat_attachment
- room_chat_no — NUMBER — NOT NULL
- attachment_no — NUMBER — NOT NULL
room_user
- room_no — NUMBER — NOT NULL
- member_no — NUMBER — NOT NULL
- last_read_time — TIMESTAMP
- room_chat_read — VARCHAR2(1)
token
- token_no — NUMBER — NOT NULL
- token_value — varchar2(255)
- token_time — SYSTIMESTAMP
- token_target — varchar2(20) — NOT NULL