마지막

테이블 (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