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