출석부
테이블 (19)
announcement_reactions
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- announcement_id — integer — NOT NULL
- reaction_type — public.reaction_type
- created_at — timestamp
announcements
- id — serial — 기본 키 — NOT NULL
- created_by — uuid — NOT NULL
- department_id — integer — NOT NULL
- title — character — NOT NULL
- content — text — NOT NULL
- is_important — boolean
- view_count — integer
- updated_at — timestamp
- created_at — timestamp
attendances
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- worship_id — integer — NOT NULL
- group_id — integer — NOT NULL
- check_by — uuid
- attended_at — timestamp
- status — public.attendance_status — NOT NULL
- comment — text — ext nul
- created_at — timestamp
departments
- id — serial — 기본 키 — NOT NULL
- name — character — NOT NULL
- description — text
- theme_color — character
- slug — character
- created_at — timestamp
donations
- id — serial — 기본 키 — NOT NULL
- department_id — integer — NOT NULL
- created_by — uuid — NOT NULL
- updated_by — uuid
- donor_name — character
- amount — numeric(10, 2) — NOT NULL
- donation_type — character — NOT NULL
- donation_date — date — NOT NULL
- description — text
- updated_at — timestamp
- created_at — timestamp
expenses
- id — serial — 기본 키 — NOT NULL
- department_id — integer — NOT NULL
- created_by — uuid — NOT NULL
- updated_by — uuid
- expense_name — character — NOT NULL
- expense_category — character
- expense_date — date — NOT NULL
- receipt_url — character
- description — text
- amount — numeric(10, 2) — NOT NULL
- updated_at — timestamp
- created_at — timestamp
groups
- id — serial — 기본 키 — NOT NULL
- department_id — integer — NOT NULL
- parent_group_id — integer
- name — character — NOT NULL
- description — character
- created_at — timestamp
permissions
- id — serial — 기본 키 — NOT NULL
- code — character — NOT NULL
- description — text — NOT NULL
- created_at — timestamp
prayer_reactions
- id — bigserial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- prayer_request_id — integer — NOT NULL
- created_at — timestamp
prayer_requests
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- department_id — integer — NOT NULL
- group_id — integer
- title — character — NOT NULL
- content — text — NOT NULL
- status — public.prayer_status
- is_anonymous — boolean
- prayer_count — integer
- updated_at — timestamp
- created_at — timestamp
roles
- id — serial — 기본 키 — NOT NULL
- role — public.user_role — NOT NULL
- role_name — character — NOT NULL
- description — text — NOT NULL
- created_at — timestamp
security_logs
- id — serial — 기본 키 — NOT NULL
- admin_id — uuid — NOT NULL
- user_id — uuid — NOT NULL
- permission_id — integer — NOT NULL
- is_access — boolean
- description — text
- ip_address — character
- user_agent — text
- is_suspicious — boolean
- created_at — timestamp
social_links
- id — serial — 기본 키 — NOT NULL
- department_id — integer — NOT NULL
- link_name — character — NOT NULL
- link_url — character — NOT NULL
- image_url — character
- display_order — integer
- is_active — boolean
- updated_at — timestamp
- created_at — timestamp
user_department_roles
- id — serial — 기본 키 — NOT NULL
- user_department_id — integer — NOT NULL
- user_role_id — integer — NOT NULL
- created_at — timestamp
user_departments
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- department_id — integer — NOT NULL
- is_active — boolean
- assigned_at — timestamp
- created_at — timestamp
user_groups
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- group_id — integer — NOT NULL
- joined_at — timestamp
- created_at — timestamp
user_roles
- id — serial — 기본 키 — NOT NULL
- user_id — uuid — NOT NULL
- role_id — integer — NOT NULL
- department_id — integer — NOT NULL
- assigned_at — timestamp
- created_at — timestamp
users
- id — uuid — 기본 키 — NOT NULL
- default_department_id — integer
- email — character — NOT NULL
- name — character — NOT NULL
- password_hash — text
- phone — character — NOT NULL
- birth_date — date — NOT NULL
- gender — public.user_gender
- profile_image_url — text
- oauth_provider — character
- oauth_email — character
- oauth_metadata — jsonb
- remember_login — boolean
- parent_name — character
- parent_phone — character
- approval_status — public.user_approval_status
- created_at — timestamp
worships
- id — serial — 기본 키 — NOT NULL
- department_id — integer — NOT NULL
- name — character — NOT NULL
- description — text — NOT NULL
- is_required — boolean — NOT NULL
- created_at — timestamp