JAttendance - 2025-07-10 15:27:35 - 2025-07-10 15:27:49

Tables (16)

announcement_reactions

  • reaction_id — BIGINT — Primary key
  • announcement_id (announcement_id2) — BIGINT — Foreign key
  • user_id (user_id2) — BIGINT — Foreign key
  • reaction_type — ENUM('LIKE', 'GOOD', 'SAD', 'FUNNY') — NOT NULL
  • created_at — TIMESTAMP
  • announcement_id — BIGINT — Foreign key → announcements.announcement_id
  • user_id — BIGINT — Foreign key → users.user_id

announcements

  • announcement_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • user_id (user_id2) — BIGINT — Foreign key
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • is_important — BOOLEAN
  • view_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id

attendances

  • attendance_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id
  • attendance_date — DATE — NOT NULL
  • attendance_time (Field2) — TIME
  • attendance_status — ENUM('PRESENT', 'ABSENT', 'LATE', 'ONLINE')
  • check_in_time — TIMESTAMP
  • check_in_method — ENUM('LOCATION', 'QR_CODE', 'MANUAL') — NOT NULL
  • checked_by (Field) — UUID
  • location_lat — DECIMAL(10, 8)
  • location_lng — DECIMAL(11, 8)
  • qr_code_id — VARCHAR(100)
  • comments — TEXT
  • created_by — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

donations

  • donation_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • user_id (author_id) — BIGINT — Foreign key
  • donor_name — VARCHAR(100)
  • amount — DECIMAL(10, 2) — NOT NULL
  • donation_type — VARCHAR(50)
  • donation_date — DATE — NOT NULL
  • description — TEXT
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • group_id — UUID — Foreign key → groups.group_id
  • user_id — BIGINT — Foreign key → users.user_id

events

  • event_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • user_id (created_by) — BIGINT — Foreign key
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • event_date — DATE — NOT NULL
  • start_time — TIME
  • end_time — TIME
  • location — VARCHAR(200)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id

expenses

  • expense_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • user_id (author_id) — BIGINT — Foreign key
  • 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_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id

groups

  • group_id — UUID — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • group_name — VARCHAR(100) — NOT NULL
  • group_type — ENUM('DEPARTMENT', 'SUBGROUP') — NOT NULL
  • parent_group_id — UUID
  • group_code — VARCHAR(20)
  • year — INT — NOT NULL
  • description — TEXT
  • settings — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

locations

  • location_id — BIGINT
  • group_id — BIGINT — NOT NULL
  • location_name — VARCHAR(100) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • radius_meters — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

prayer_reactions

  • reaction_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key
  • prayer_id (prayer_id2) — BIGINT — Foreign key → prayer_requests.prayer_id
  • created_at — TIMESTAMP

prayer_requests

  • prayer_id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key
  • group_id (group_id2) — UUID — Foreign key
  • 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
  • user_id — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id

qr_codes

  • qr_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • qr_code — VARCHAR(100) — NOT NULL
  • valid_from — TIMESTAMP — NOT NULL
  • valid_until — TIMESTAMP — NOT NULL
  • is_active — BOOLEAN
  • created_by — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • group_id — UUID — Foreign key → groups.group_id

roles

  • role_id — UUID — Primary key
  • role_name — ENUM('MEMBER', 'LEADER', 'ADMIN', 'SUPER_ADMIN') — NOT NULL
  • role_description — TEXT
  • permissions — JSON
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

security_logs

  • log_id — BIGINT — Primary key
  • user_id (admin_id) — BIGINT — Foreign key
  • user_id — BIGINT — Foreign key
  • action_type — ENUM('LOGIN', 'LOGOUT', 'PERMISSION_CHANGE', 'DELETE', 'CREATE', 'UPDATE', 'PASSWORD_RESET') — NOT NULL
  • description — TEXT
  • ip_address — VARCHAR(45)
  • user_agent — TEXT
  • is_suspicious — BOOLEAN
  • created_at — TIMESTAMP
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • user_id (user_id3) — BIGINT — Foreign key → users.user_id

social_links

  • link_id — BIGINT — Primary key
  • group_id (group_id2) — UUID — Foreign key
  • link_name — VARCHAR(50) — NOT NULL
  • image_url (Field) — VARCHAR(500)
  • url — VARCHAR(500) — NOT NULL
  • display_order — INT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • group_id — UUID — Foreign key → groups.group_id

user_group_roles

  • id — UUID — Primary key
  • user_id — BIGINT — Foreign key
  • group_id (group_id2) — UUID — Foreign key
  • role_id (role_id2) — UUID — Foreign key
  • is_default_group — BOOLEAN
  • is_active — BOOLEAN
  • assigned_by — UUID
  • assigned_at — TIMESTAMP
  • expires_at — TIMESTAMP
  • notes — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id (user_id2) — BIGINT — Foreign key → users.user_id
  • group_id — UUID — Foreign key → groups.group_id
  • role_id — UUID — Foreign key → roles.role_id

users

  • user_id — BIGINT — Primary key
  • username — BIGINT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(100)
  • name — BIGINT — NOT NULL
  • phone — VARCHAR(100)
  • birth_date — BIGINT
  • gender (Field) — VARCHAR(100)
  • profile_image_url — VARCHAR(100)
  • oauth_provider — VARCHAR(100)
  • oauth_id — VARCHAR(100)
  • attendance_level — BIGINT
  • default_group_id — BIGINT
  • is_active — BIGINT
  • remember_login — BIGINT
  • organization (Field2) — VARCHAR(200)
  • evangelist_name (Field3) — VARCHAR(100)
  • evangelist_relation (Field4) — VARCHAR(100)
  • baptism_status (Field5) — VARCHAR(100)
  • parent_name (Field6) — VARCHAR(100)
  • parent_phone (Field7) — VARCHAR(100)
  • created_at — BIGINT
  • updated_at — TIMESTAMP