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