TF 셀모임

테이블 (11)

group

  • id — uuid — 기본 키 — NOT NULL
  • leader_id — uuid — NOT NULL
  • community — smallint — NOT NULL

group_meeting (cell_meeting)

  • id — uuid — 기본 키
  • group_id — uuid — NOT NULL
  • meeting_date — date — NOT NULL
  • status — text — NOT NULL
  • notes — text
  • created_by — uuid — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

group_meeting_record (cell_meeting_record)

  • id — uuid — 기본 키
  • cell_meeting_id — uuid — 기본 키 — NOT NULL
  • member_id — uuid — NOT NULL
  • cell_attended — boolean — NOT NULL
  • worship_attended — boolean — NOT NULL
  • prayer_request — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

group_member

  • group_id — uuid — 기본 키 — NOT NULL
  • member_id — uuid — 기본 키 — NOT NULL

internal_team_application

  • id — bigint — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • name — text — NOT NULL
  • email — text — NOT NULL
  • phone — text — NOT NULL
  • interest — text — NOT NULL
  • confirmation — boolean — NOT NULL
  • tithe — boolean — NOT NULL

member

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • name_in_korean — text
  • name — text
  • sex — smallint
  • dob — date
  • phone_number — text
  • email — text
  • address — text
  • is_baptized — boolean
  • is_confirmed — boolean
  • status — text
  • church_id — integer
  • updated_at — timestamp

permission

  • id — bigint — 기본 키 — NOT NULL
  • slug — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

role

  • id — bigint — 기본 키 — NOT NULL
  • description — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

role_permission

  • id — bigint — 기본 키 — NOT NULL
  • role_id — bigint — NOT NULL
  • permission_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

user

  • id — uuid — 기본 키 — NOT NULL
  • created_at — timestamp — NOT NULL
  • google_id — numeric — NOT NULL
  • email — text — NOT NULL
  • given_name — text — NOT NULL
  • family_name — text — NOT NULL
  • name — text — NOT NULL
  • image_url — text

user_role

  • id — bigint — 기본 키 — NOT NULL
  • user_id — uuid — NOT NULL
  • role_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL