todo

Tables (29)

attendances

  • attendance_id — BIGSERIAL
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • target_date — DATE — NOT NULL — 출근
  • scheduled_start_time — TIME — 예정
  • scheduled_end_time — TIME — 예정
  • clock_in — TIMESTAMPTZ — 출근
  • clock_out — TIMESTAMPTZ — 퇴근
  • status — VARCHAR(20) — NOT NULL — 근태
  • overtime — BOOLEAN — 연장근무
  • break_minutes — INTEGER — NOT NULL — 휴게시간(분)
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

auction_bids

  • bid_id — BIGSERIAL
  • auction_id — BIGINT — Foreign key → shift_auctions.auction_id — NOT NULL — 경매
  • bidder_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 입찰자
  • bid_wage — INTEGER — NOT NULL — 입찰액
  • bid_time — TIMESTAMPTZ — NOT NULL — 입찰시간

auction_winners

  • winner_record_id — BIGSERIAL
  • auction_id — BIGINT — Foreign key → shift_auctions.auction_id — NOT NULL — 경매
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 사용자
  • selected_at — TIMESTAMP — 낙찰

boards

  • board_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • name — VARCHAR(50) — NOT NULL — 게시판
  • description — VARCHAR(255) — 게시판
  • board_type — VARCHAR(20) — NOT NULL — 게시판
  • is_active — BOOLEAN — NOT NULL — 활성화
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

chat_direct_pairs

  • pair_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • user1_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자1
  • user2_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자2
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL — DM

chat_messages

  • message_id — BIGSERIAL
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL — 채팅방
  • sender_id — BIGINT — Foreign key → users.user_id — 송신자
  • message_type — VARCHAR(20) — NOT NULL — 메시지
  • content — TEXT — 본문
  • file_url — VARCHAR(255) — 파일
  • meta_json — JSONB — 첨부/부가
  • sent_at — TIMESTAMPTZ — NOT NULL — 발송
  • read_count — INTEGER — NOT NULL — 읽은
  • is_deleted — BOOLEAN — NOT NULL — 삭제
  • deleted_at — TIMESTAMPTZ — 삭제

chat_room_members

  • room_member_id — BIGSERIAL
  • room_id — BIGINT — Foreign key → chat_rooms.room_id — NOT NULL — 채팅방
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자
  • member_role — VARCHAR(20) — NOT NULL — 멤버
  • joined_at — TIMESTAMPTZ — NOT NULL — 참여
  • left_at — TIMESTAMPTZ — 퇴장
  • last_read_message_id — BIGINT — 마지막
  • last_read_at — TIMESTAMPTZ — 마지막
  • mute_until — TIMESTAMPTZ — 알림

chat_rooms

  • room_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • room_type — VARCHAR(20) — NOT NULL — 방
  • name — VARCHAR(100) — 채팅방
  • created_by — BIGINT — Foreign key → users.user_id — 생성자
  • last_message_id — BIGINT — 마지막
  • last_message_at — TIMESTAMPTZ — 마지막
  • sort_priority — INTEGER — NOT NULL — 정렬
  • is_archived — BOOLEAN — NOT NULL — 보관
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

contract_signatures

  • signature_id — BIGSERIAL
  • contract_id — BIGINT — Foreign key → employment_contracts.contract_id — NOT NULL — 근로계약서
  • signed_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 서명자
  • signer_role — VARCHAR(20) — NOT NULL — 서명자
  • signature_image_url — VARCHAR(255) — NOT NULL — 서명
  • signed_at — TIMESTAMPTZ — NOT NULL — 서명

documents

  • doc_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 회원
  • doc_type — VARCHAR(50) — NOT NULL — 서류
  • file_url — VARCHAR(255) — NOT NULL — 문서
  • expire_date — DATE — 유효기간
  • status — VARCHAR(20) — NOT NULL — 문서
  • uploaded_at — TIMESTAMPTZ — NOT NULL — 업로드

employee_documents

  • doc_id — BIGSERIAL
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • doc_type — VARCHAR(50) — NOT NULL — 문서
  • file_url — VARCHAR(255) — NOT NULL — 문서
  • status — VARCHAR(20) — NOT NULL — 문서
  • expire_date — DATE — 만료일
  • uploaded_at — TIMESTAMPTZ — NOT NULL — 업로드

employment_contracts

  • contract_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • contract_title — VARCHAR(100) — NOT NULL — 제목
  • contract_body — TEXT — NOT NULL — 계약
  • status — VARCHAR(20) — NOT NULL — 상태
  • signed_owner_at — TIMESTAMPTZ — 사장
  • signed_employee_at — TIMESTAMPTZ — 서명
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

notifications

  • notification_id — BIGSERIAL
  • receiver_id — BIGINT — Foreign key → users.user_id — NOT NULL — 수신자
  • title — VARCHAR(100) — NOT NULL — 제목
  • body — TEXT — NOT NULL — 내용
  • type — VARCHAR(20) — NOT NULL — 알림타입
  • target_id — BIGINT — 이동용
  • is_read — BOOLEAN — NOT NULL — 읽음
  • created_at — TIMESTAMP — NOT NULL — 생성일시
  • modified_at — TIMESTAMP — NOT NULL — 수정일시

payout_transactions

  • payout_id — BIGSERIAL
  • payroll_id — BIGINT — Foreign key → payrolls.payroll_id — NOT NULL — 급여대장
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • amount — BIGINT — NOT NULL — 지급
  • status — VARCHAR(20) — NOT NULL — 송금
  • payment_method — VARCHAR(20) — NOT NULL — 지급
  • external_tx_id — VARCHAR(100) — 영수증
  • paid_at — TIMESTAMPTZ — 지급
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시

payroll_details

  • detail_id — BIGSERIAL
  • payroll_id — BIGINT — Foreign key → payrolls.payroll_id — NOT NULL — 급여대장
  • detail_type — VARCHAR(20) — NOT NULL — 항목
  • item_name — VARCHAR(50) — NOT NULL — 항목
  • amount — BIGINT — NOT NULL — 금액
  • calculation_formula — VARCHAR(255) — 계산식
  • work_minutes — INTEGER — NOT NULL — 근무시간(m)
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시

payrolls

  • payroll_id — BIGSERIAL
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • target_month — DATE — NOT NULL — 대상월
  • total_work_minutes — INTEGER — NOT NULL — 총
  • night_work_minutes — INTEGER — NOT NULL — 야간
  • basic_pay — BIGINT — NOT NULL — 기본급
  • total_allowance — BIGINT — NOT NULL — 총
  • total_deduction — BIGINT — NOT NULL — 총
  • net_pay — BIGINT — NOT NULL — 실수령액
  • is_approved — BOOLEAN — NOT NULL — 최종
  • approved_at — TIMESTAMPTZ — 최종
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

post_comments

  • comment_id — BIGSERIAL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL — 게시글
  • writer_id — BIGINT — Foreign key → store_employees.employee_id — 작성자
  • parent_comment_id — BIGINT — Foreign key → post_comments.comment_id — 부모
  • content — TEXT — NOT NULL — 댓글
  • is_deleted — BOOLEAN — NOT NULL — 삭제여부
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

post_images

  • image_id — BIGSERIAL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL — 게시글
  • image_url — VARCHAR(255) — NOT NULL — 이미지
  • origin_name — VARCHAR(255) — 원본
  • name — VARCHAR(255) — 파일명
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

posts

  • post_id — BIGSERIAL
  • board_id — BIGINT — Foreign key → boards.board_id — NOT NULL — 게시판
  • writer_id — BIGINT — Foreign key → store_employees.employee_id — 작성자
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — TEXT — NOT NULL — 본문
  • view_count — INTEGER — NOT NULL — 조회수
  • is_deleted — BOOLEAN — NOT NULL — 삭제여부
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

shift_auctions

  • auction_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • target_date — DATE — NOT NULL — 근무일
  • deadline — TIMESTAMP — 마감
  • start_time — TIME — NOT NULL — 출근
  • end_time — TIME — NOT NULL — 퇴근
  • max_wage — INTEGER — NOT NULL — 상한선
  • min_wage — INTEGER — NOT NULL — 하한선
  • status — VARCHAR(20) — NOT NULL — 경매
  • recruit_count — INTEGER — NOT NULL — 모집
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

store_employees

  • employee_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 사용자
  • status — VARCHAR(20) — NOT NULL — 재직
  • position — VARCHAR(50) — 직급
  • hourly_wage — INTEGER — NOT NULL — 시급
  • tax_type — VARCHAR(20) — NOT NULL — 소득세
  • worked_minutes — INTEGER — NOT NULL — 이번
  • will_working_minutes — INTEGER — NOT NULL — 이번
  • hire_date — DATE — 고용일
  • dependents_count — INTEGER — NOT NULL — 부양가족수
  • include_holiday_pay — BOOLEAN — NOT NULL — 주휴수당
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

store_tasks

  • task_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • creator_user_id — BIGINT — Foreign key → users.user_id — 생성자
  • title — VARCHAR(120) — NOT NULL — 제목
  • description — VARCHAR(1000) — NOT NULL — 상세
  • due_at — TIMESTAMPTZ — NOT NULL — 마감
  • status — VARCHAR(20) — NOT NULL — 진행
  • completed_at — TIMESTAMPTZ — 완료
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

stores

  • store_id — BIGSERIAL
  • owner_id — BIGINT — Foreign key → users.user_id — NOT NULL — 소유자
  • store_name — VARCHAR(100) — NOT NULL — 매장명
  • address — VARCHAR(255) — NOT NULL — 주소
  • phone — VARCHAR(20) — 연락처
  • qr_code — VARCHAR(255) — QR코드
  • latitude — DOUBLE — 위도
  • longitude — DOUBLE — 경도
  • is_over_5_employees — BOOLEAN — NOT NULL — 5인
  • is_closed — BOOLEAN — NOT NULL — 폐업
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

task_assignees

  • assignee_id — BIGSERIAL
  • task_id — BIGINT — Foreign key → store_tasks.task_id — NOT NULL — 할일
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 담당
  • is_completed — BOOLEAN — NOT NULL — 완료
  • completed_at — TIMESTAMPTZ — 직원
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

task_history

  • history_id — BIGSERIAL
  • task_id — BIGINT — Foreign key → store_tasks.task_id — NOT NULL — 할일
  • changed_by — BIGINT — Foreign key → users.user_id — 변경자
  • from_status — VARCHAR(20) — 이전
  • to_status — VARCHAR(20) — NOT NULL — 변경된
  • changed_at — TIMESTAMPTZ — NOT NULL — 변경

task_images

  • image_id — BIGSERIAL
  • task_id — BIGINT — Foreign key → store_tasks.task_id — NOT NULL — 할일
  • image_url — VARCHAR(255) — NOT NULL — 이미지
  • origin_name — VARCHAR(255) — 원본
  • name — VARCHAR(255) — 파일명
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

tax_file_jobs

  • job_id — BIGSERIAL
  • store_id — BIGINT — Foreign key → stores.store_id — NOT NULL — 매장
  • target_month — DATE — NOT NULL — 대상월
  • job_status — VARCHAR(20) — NOT NULL — 진행
  • file_path — VARCHAR(255) — 파일경로
  • error_message — TEXT — 에러
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • finished_at — TIMESTAMPTZ — 완료

users

  • user_id — BIGSERIAL
  • login_type — VARCHAR(20) — NOT NULL — 로그인
  • password — VARCHAR(200) — 비밀번호
  • role — VARCHAR(20) — 역할
  • name — VARCHAR(50) — NOT NULL — 이름
  • phone — VARCHAR(20) — 연락처
  • email — VARCHAR(100) — NOT NULL — 이메일
  • is_withdraw — BOOLEAN — NOT NULL — 탈퇴여부
  • withdrawn_at — TIMESTAMPTZ — 탈퇴
  • birth_date — DATE — 생년월일
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시

work_schedules

  • schedule_id — BIGSERIAL
  • employee_id — BIGINT — Foreign key → store_employees.employee_id — NOT NULL — 직원
  • day_of_week — SMALLINT — NOT NULL — 요일
  • start_time — TIME — NOT NULL — 출근
  • end_time — TIME — NOT NULL — 퇴근
  • break_minutes — INTEGER — NOT NULL — 휴게
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일시
  • updated_at — TIMESTAMPTZ — NOT NULL — 수정일시