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