hanhaw

Tables (12)

Agenda (안건)

  • agenda_id (아이디) — INT — Primary key — NOT NULL
  • board_meeting_id (이사회회의아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • user_id (의사록작성자(user_id)) — INT — Foreign key → User.user_id — NOT NULL
  • agenda_title (안건제목) — VARCHAR
  • agenda_description (의사록본문내용) — VARCHAR
  • agenda_status (안건상태) — CHAR
  • agenda_creation_date (안건생성일자) — DATE
  • agenda_last_modified_date (안건마지막수정일자) — DATE

Approval (결재)

  • approval_id (아이디) — INT — Primary key — NOT NULL
  • board_meeting_id (이사회회의아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • board_minutes_id (이사회의사록아이디) — INT — Foreign key → Board_Minutes.board_minutes_id — NOT NULL
  • approval_status (결재상태) — CHAR
  • approval_comments (결재자의견) — VARCHAR
  • approval_date (결재날짜) — DATE
  • approval_feedback (검토내용) — VARCHAR
  • signature_time (서명시간) — DATE
  • signature_file_path (서명파일경로) — VARCHAR
  • attachment_id (첨부파일아이디) — INT

Attachment (첨부파일)

  • attachment_id (Key) — INT — Primary key — NOT NULL
  • board_meeting_id (이사회회의아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • board_minutes_id (이사회의사록아이디) — INT — Foreign key → Board_Minutes.board_minutes_id — NOT NULL
  • attachment_type (첨부파일구분) — CHAR
  • attachment_name (첨부파일이름) — VARCHAR
  • attachment_path (첨부파일경로) — VARCHAR
  • attachment_upload_date (업로드날짜) — DATE

Attendee_Management (참석자관리)

  • attendee_id (아이디) — INT — Primary key — NOT NULL
  • board_meeting_id (이사회회의아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • user_id (참석자아이디(user_id)) — INT — Foreign key → User.user_id — NOT NULL
  • attendee_role (참석자역할) — CHAR
  • attendee_status (참석상태) — CHAR
  • attendee_creation_date (참석자정보생성일자) — DATE
  • attendee_last_modified_date (참석자정보마지막수정일자) — DATE

Board_Meeting (이사회회의)

  • board_meeting_id (아이디) — INT — Primary key — NOT NULL
  • board_meeting_organizer (주최자(user_id/FK)) — INT — Foreign key → User.user_id — NOT NULL
  • board_meeting_date (회의일자) — DATE
  • board_meeting_start_time (회의시작시간) — DATE
  • board_meeting_location (회의장소(대면/비대면 여부포함)) — VARCHAR
  • boar_meeting_status (회의상태) — CHAR
  • board_meeting_main_agenda (회의 주요안건) — VARCHAR
  • board_meeting_creation_date (회의생성일자) — DATE
  • board_meeting_last_modified_date (회의정보마지막수정일자) — DATE

Board_Minutes (이사회의사록)

  • board_minutes_id (아이디) — INT — Primary key — NOT NULL
  • board_meeting_id (이사회회의아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • user_id (의사록 작성자아이디) — INT — Foreign key → User.user_id — NOT NULL
  • board_minutes_title (의사록제목) — VARCHAR
  • board_minutes_content (의사록본문내용) — VARCHAR
  • board_minutes_attendee_list (참석자명단) — VARCHAR
  • board_minutes_decisions (주요결정사항) — VARCHAR
  • board_minutes_attachment_path (첨부파일경로) — VARCHAR
  • board_minutes_creation_date (의사록생성일자) — DATE
  • board_minutes_last_modified_date (의사록마지막수정일자) — DATE

Log_Management (로그)

  • log_management_id (아이디) — Primary key — NOT NULL
  • user_id (사용자아이디) — INT — Foreign key → User.user_id — NOT NULL
  • log_management_performed_action (수행작업) — VARCHAR
  • log_management_action_timestamp (작업수행시간) — DATE
  • log_management_ip_address (접속IP주소) — VARCHAR
  • log_management_device_info (접속장치정보) — VARCHAR

Minutes_Template (의사록양식)

  • minutes_template_id (양식아이디) — INT — Primary key — NOT NULL
  • user_id (양식작성자) — INT — Foreign key → User.user_id — NOT NULL
  • minutes_template_name (양식이름) — VARCHAR
  • minutes_template_creation_date (양식작성날짜) — DATE
  • minutes_template_active_status (활성화상태) — CHAR

Notification_Management (알림관리)

  • notification_management_id (알림고유아이디) — INT — Primary key — NOT NULL
  • board_meeting_id (의사회아이디) — INT — Foreign key → Board_Meeting.board_meeting_id — NOT NULL
  • user_id (사용자아이디) — INT — Foreign key → User.user_id — NOT NULL
  • notification_management_type (알림유형) — CHAR
  • notification_management_message_content (메시지내용) — VARCHAR
  • notification_management_send_time (발송시간) — DATE
  • notification_management_send_status (발송상태) — CHAR
  • notification_management_read_status (알림열람여부) — CHAR

Notification_Type (알림유형)

  • notification_type (알림유형아이디) — INT — Primary key — NOT NULL
  • notification_message (알림메시지) — VARCHAR
  • notification_creation_date (알림생성날짜) — CHAR

Report (보고서)

  • report_id (보고서아이디) — INT — Primary key — NOT NULL
  • report_type (보고서유형) — CHAR
  • report_creation_date (생성날짜) — DATE
  • report_content (ghkftjdghktkdxo) — CHAR

User (사용자)

  • user_id (아이디) — INT — Primary key — NOT NULL
  • user_pwd (패스워드) — VARCHAR
  • user_name (이름) — VARCHAR
  • auth_code (권한) — CHAR
  • user_status (사용자상태) — CHAR
  • user_in_date (입사일) — DATE
  • user_end_date (퇴사일) — DATE
  • user_email (이메일) — VARCHAR
  • user_tel (연락처) — VARCHAR
  • user_login_time (로그인시간) — DATE