마지막
테이블 (24)
approval
- approval_id — BIGINT
- template_id — BIGINT — NOT NULL
- requester_id — VARCHAR(100) — NOT NULL — 결재 요청자 ID
- company_id — BIGINT — NOT NULL — 회사 ID
- approval_status — VARCHAR(50) — 전체 결재 상태
- request_date — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- content — JSON — NOT NULL — 결재 내용
approval_history
- history_id — BIGINT
- approval_id — BIGINT — NOT NULL
- member_id — VARCHAR(100) — NOT NULL — 결재자 ID
- status — VARCHAR(50) — NOT NULL — 결재 상태 (APPROVED, REJECTED)
- comment — TEXT — EXT NULL COMMENT '결재자 의견
- approval_date — TIMESTAMP — 결재 완료 날짜
approval_line
- approval_line_id — BIGINT
- approval_id — BIGINT — NOT NULL
- step_order — INT — NOT NULL — 결재 순서
- department_id — BIGINT — 결재자 부서
- team_id — BIGINT — 결재자 팀
- position_id — BIGINT — 결재자 직급
- member_id — VARCHAR(100) — NOT NULL — 결재자 ID
- status — VARCHAR(50) — 결재 상태 (PENDING, APPROVED, REJECTED)
- comment — TEXT — EXT NULL COMMENT '결재자 코멘트
- approval_date — TIMESTAMP — 결재 완료 날짜
attendance
- attendance_id — BIGINT
- member_id — VARCHAR(100) — NOT NULL
- check_in — TIMESTAMP
- check_out — TIMESTAMP
- attendance_date — DATE
- status — VARCHAR(100) — 출근, 휴가, 반차 등
category
- category_id — BIGINT
- category_name — VARCHAR(50)
- color — VARCHAR(255) — NOT NULL
chat
- chat_id — BIGINT
- chatroom_id — BIGINT — NOT NULL
- member_id — VARCHAR(100) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255)
- sent_at — TIMESTAMP
- is_deleted — BOOLEAN — NOT NULL
chatroom
- chatroom_id — BIGINT
- chatroom_kind_id — BIGINT — NOT NULL
- company_id — BIGINT — NOT NULL
- created_by_member_id — VARCHAR(100) — NOT NULL
- chatroom_name — VARCHAR(50) — NOT NULL
chatroom_kind
- chatroom_kind_id — BIGINT
- kind — VARCHAR(50) — NOT NULL — 회사, 부서, 팀, 프로젝트 등
company
- company_id — BIGINT
- company_name — VARCHAR(255) — NOT NULL
- company_address — VARCHAR(255) — NOT NULL
- company_url — VARCHAR(100)
company_custom_template
- company_id — BIGINT — 기본 키 — NOT NULL
- template_id — BIGINT — 기본 키 — NOT NULL
- custom_structure — JSON — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
department
- department_id — BIGINT
- company_id — BIGINT — NOT NULL
- department_name — VARCHAR(50) — NOT NULL
file
- file_id — BIGINT
- company_id — BIGINT — NOT NULL
- member_id — VARCHAR(100) — NOT NULL — 파일을 업로드한 회원
- file_name — VARCHAR(255) — NOT NULL — 파일 이름
- file_url — VARCHAR(255) — NOT NULL — 파일이 저장된 URL
- file_type — VARCHAR(50) — NOT NULL — 파일 유형 (예: 이미지, PDF 등)
- file_size — BIGINT — 파일 크기 (바이트)
- uploaded_at — TIMESTAMP — 파일 업로드 시간
- is_deleted — BOOLEAN — 파일 삭제 여부
- associated_type — VARCHAR(50) — NOT NULL — 연관된 도메인 (CHATROOM, MESSAGE, APPROVAL 등)
- associated_id — BIGINT — NOT NULL — 연관된 엔티티의 ID (예: message_id, approval_id)
form_template
- template_id — BIGINT
- form_name — VARCHAR(100) — NOT NULL
- form_structure — JSON — NOT NULL
- is_active — BOOLEAN — NOT NULL
invitation_code
- code_id — BIGINT
- company_id — BIGINT — NOT NULL
- code — VARCHAR(100) — NOT NULL
- expiration_date — TIMESTAMP
- usage_limit — INT — 코드 사용 가능 횟수
- usage_count — INT — 코드가 사용된 횟수
- is_active — BOOLEAN
- created_at — TIMESTAMP
- created_by — VARCHAR(100)
meeting_room
- room_id — BIGINT
- company_id — BIGINT — NOT NULL
- room_name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- capacity — INT — NOT NULL — 최대 수용 인원
- room_status — VARCHAR(50) — 회의실 상태 (AVAILABLE, UNAVAILABLE)
meeting_room_reservation
- reservation_id — BIGINT
- room_id — BIGINT — NOT NULL
- member_id — VARCHAR(100) — NOT NULL — 예약을 한 회원 ID
- company_id — BIGINT — NOT NULL — 회의실 예약이 속한 회사
- start_time — TIMESTAMP — NOT NULL — 회의 시작 시간
- end_time — TIMESTAMP — NOT NULL — 회의 종료 시간
- status — VARCHAR(50) — NOT NULL — 예약 상태 (CONFIRMED, CANCELED)
- created_at — TIMESTAMP — 예약 요청 시간
- cancel_reason — VARCHAR(255) — 예약 취소 사유
- version — BIGINT — NOT NULL — 낙관적 락을 위한 버전
member_detail
- member_detail_id — BIGINT
- member_id — VARCHAR(100) — NOT NULL
- position_id — BIGINT — NOT NULL
- department_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- status — VARCHAR(100) — NOT NULL — 퇴직, 출장, 출산휴가 등
- profile_url — VARCHAR(255) — 프로필 사진 URL
- hire_date — DATE
members
- member_id — VARCHAR(100)
- member_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- member_password — VARCHAR(100) — NOT NULL
- role — ENUM('ROLE_USER', 'ROLE_EMPLOYEE', 'ROLE_MANAGER', 'ROLE_ADMIN') — NOT NULL
- company_id — BIGINT
memo
- memo_id — BIGINT
- member_id — VARCHAR(100) — NOT NULL
- content — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP
message
- message_id — BIGINT
- sender_id — VARCHAR(100) — NOT NULL
- receiver_id — VARCHAR(100) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(255) — NOT NULL
- sent_at — TIMESTAMP
- is_read — BOOLEAN — NOT NULL — 메시지 읽음 여부
- is_deleted — BOOLEAN — NOT NULL — 메시지 삭제 여부
- delete_date — TIMESTAMP — 삭제된 날짜
position
- position_id — BIGINT
- company_id — BIGINT — NOT NULL
- position_name — VARCHAR(50) — NOT NULL
project_member
- project_member_id — BIGINT
- chatroom_id — BIGINT — NOT NULL
- member_id — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL — 방장, 부방장, 일반 등
schedule
- schedule_id — BIGINT
- member_id — VARCHAR(100) — NOT NULL — 일정을 등록한 회원
- title — VARCHAR(255)
- description — VARCHAR(255)
- start_date — TIMESTAMP
- end_date — TIMESTAMP
- is_all_day — BOOLEAN — 당일 일정 여부
- category_id — BIGINT — NOT NULL
- category_num — BIGINT — 추가적인 카테고리 분류 번호
team
- team_id — BIGINT
- department_id — BIGINT — NOT NULL
- team_name — VARCHAR(50) — NOT NULL