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 — 수정일시