(공개용)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