JAttendance with gpt
Tables (21)
announcement_reactions
- reaction_id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- announcement_id — UUID — Foreign key → announcements.announcement_id
- reaction_type — ENUM('LIKE', 'GOOD', 'SAD', 'FUNNY')
- created_at — TIMESTAMP
announcements
- announcement_id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- department_id (id3) — UUID — Foreign key → departments.id
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_important — BOOLEAN
- view_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
attendances
- id — UUID — Primary key
- user_id (id3) — UUID — Foreign key → users.id
- worship_id (id2) — UUID — Foreign key → worships.id
- checked_by (id4) — UUID — Foreign key → users.id
- group_id — UUID
- attended_at — TIMESTAMPTZ
- status — TEXT
- comment — TEXT
- check_in_method (Field2) — ENUM
departments
- id — UUID — Primary key
- name — TEXT — NOT NULL
- description — TEXT
- theme_color — TEXT
- created_at — TIMESTAMPTZ
donations
- donation_id — UUID — Primary key
- department_id (id2) — UUID — Foreign key → departments.id
- donor_name — VARCHAR(100)
- amount — DECIMAL(10, 2) — NOT NULL
- donation_type — VARCHAR(50)
- donation_date — DATE — NOT NULL
- description — TEXT
- created_by — UUID — NOT NULL
- created_at — TIMESTAMP
- updated_by (Field) — UUID
- updated_at — TIMESTAMP
expenses
- expense_id — UUID — Primary key
- department_id (id4) — UUID — Foreign key → departments.id
- created_by (id2) — UUID — Foreign key → users.id
- updated_by (id3) — UUID — Foreign key → users.id
- expense_name — VARCHAR(100) — NOT NULL
- amount — DECIMAL(10, 2) — NOT NULL
- expense_category — VARCHAR(50)
- expense_date — DATE — NOT NULL
- description — TEXT
- receipt_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
groups
- id — UUID — Primary key
- department_id (id3) — UUID — Foreign key → departments.id
- parent_group_id (id2) — UUID — Foreign key → groups.id
- name — TEXT — NOT NULL
- created_at — TIMESTAMPTZ
permissions
- id — UUID — Primary key
- code — TEXT — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
prayer_reactions
- reaction_id — BIGINT — Primary key
- user_id2 — BIGINT
- prayer_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
prayer_requests
- prayer_request_id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- department_id (id3) — UUID — Foreign key → departments.id
- group_id2 — UUID
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('PRAYING', 'ANSWERED', 'COMPLETED', 'CLOSED')
- is_anonymous — BOOLEAN
- prayer_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
role_permissions
- id — UUID — Primary key
- role_id (id3) — UUID — Foreign key → roles.id
- permission_id (id2) — UUID — Foreign key → permissions.id
- created_at — TIMESTAMP
roles
- id — UUID — Primary key
- role (scope) — TEXT — NOT NULL
- role_name (name) — TEXT — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
security_logs
- log_id — UUID — Primary key
- admin_id (id2) — UUID — Foreign key → users.id
- user_id (id3) — UUID — Foreign key → users.id
- permission_id (id4) — UUID — Foreign key → permissions.id
- is_access (Field) — BOOL
- description — TEXT
- ip_address — VARCHAR(45)
- user_agent — TEXT
- is_suspicious — BOOLEAN
- created_at — TIMESTAMP
social_links
- link_id — UUID — Primary key
- department_id (id2) — UUID — Foreign key → departments.id
- link_name — VARCHAR(50) — NOT NULL
- Field — VARCHAR(500)
- url — VARCHAR(500) — NOT NULL
- display_order — INT
- is_active — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_department_roles
- id — UUID — Primary key
- user_department_id (id2) — UUID — Foreign key → user_departments.id
- user_role_id (id3) — UUID — Foreign key → roles.id
- created_at — TIMESTAMP
user_departments
- id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- department_id (id3) — UUID — Foreign key → departments.id
- status — TEXT
- is_default — BOOLEAN
- joined_at — TIMESTAMPTZ
- created_at — TIMTESTAMP
user_group_roles
- id — UUID — Primary key
- user_group_id (id3) — UUID — Foreign key → user_groups.id
- role_id (id2) — UUID — Foreign key → roles.id
- created_at — TIMESTAMP
user_groups
- id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- group_id (id3) — UUID — Foreign key → groups.id
- joined_at — TIMESTAMPTZ
- created_at — TIMESTAMP
user_roles
- id — UUID — Primary key
- user_id (id2) — UUID — Foreign key → users.id
- role_id (id3) — UUID — Foreign key → roles.id
- department (UUID) — SERIAL
- assigned_at — TIMESTAMPTZ
- created_at — TIMESTAMP
users
- id — UUID — Primary key
- default_department_id (id2) — UUID — Foreign key → departments.id
- email — TEXT — NOT NULL
- name — TEXT — NOT NULL
- password_hash (Field) — TEXT
- phone (Field2) — TEXT
- birth_date (Field3) — TEXT
- gender (Field4) — TEXT
- profile_image_url (Field5) — TEXT
- oauth_provider (Field6) — TEXT
- oauth_id (Field7) — TEXT
- remember_login (Field9) — BOOLEAN
- parent_name (Field10) — TEXT
- parent_phone (Field11) — TEXT
- approval_status (Field8) — TEXT DEFAULT 'pending' -- 'pending', 'approved', 'rejected'
- metadata (Field12) — JSONB DEFAULT '{}"::JSONB
- created_at — TIMESTAMPTZ
worships
- id — UUID — Primary key
- department_id (id2) — UUID — Foreign key → departments.id
- name — TEXT — NOT NULL
- description — TEXT
- is_required — BOOLEAN
- created_at — TIMESTAMPTZ