JAttendance - 2025-07-10 15:27:35
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
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
attendances
- attendance_id — BIGINT — Primary key
- user_id (user_id2) — BIGINT — Foreign key
- group_id (group_id2) — UUID — Foreign key
- 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
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
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
groups
- group_id — UUID — Primary key
- user_id (user_id2) — BIGINT — Foreign key
- 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 — BIGINT — NOT NULL
- 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
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
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
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
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
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