출석부

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