JAttendance
테이블 (20)
announcement_reactions
- reaction_id — BIGINT — 기본 키
- announcement_id (announcement_id2) — BIGINT — 외래 키 → announcements.announcement_id
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id
- reaction_type — ENUM('LIKE', 'GOOD', 'SAD', 'FUNNY') — NOT NULL
- created_at — TIMESTAMP
announcements
- announcement_id — BIGINT — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id
- 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 — 기본 키
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id
- group_id (group_id2) — UUID — 외래 키 → 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
- worship_id — 외래 키 → worships.worship_id — NOT NULL
departments
- department_id — UUID — 기본 키 — NOT NULL
- user_id (leader_id) — VARCHAR(100) — 외래 키 → users.user_id
- department_name — VARCHAR(50)
- description — VARCHAR(200)
- settings — JSON
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
donations
- donation_id — BIGINT — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- user_id (author_id) — BIGINT — 외래 키 → users.user_id
- 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 — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- user_id (created_by) — BIGINT — 외래 키 → users.user_id
- 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 — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- user_id (author_id) — BIGINT — 외래 키 → users.user_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_by — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
group_role_worships
- group_role_worship — 기본 키 — NOT NULL
group_roles
- group_role_id — 기본 키 — NOT NULL
groups
- group_id — UUID — 기본 키
- department_id — UUID — 외래 키 → departments.department_id — NOT NULL
- group_name — VARCHAR(100) — 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
prayer_reactions
- reaction_id — BIGINT — 기본 키
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id
- prayer_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
prayer_requests
- prayer_id — BIGINT — 기본 키
- user_id (user_id2) — BIGINT — 외래 키 → users.user_id
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- 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 — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- 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 — 기본 키
- 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 — 기본 키
- user_id (admin_id) — BIGINT — 외래 키 → users.user_id
- user_id — BIGINT — 외래 키 → users.user_id
- 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 — 기본 키
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- 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 — 기본 키
- user_id — BIGINT — 외래 키 → users.user_id
- group_id (group_id2) — UUID — 외래 키 → groups.group_id
- role_id (role_id2) — UUID — 외래 키 → roles.role_id
- 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 — 기본 키
- department_id — UUID — 외래 키 → departments.department_id — NOT NULL
- group_id — UUID — 외래 키 → groups.group_id
- 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
worships (완ㄹ)
- worship_id — 기본 키 — NOT NULL
- worship_name
- created_at
- updated_at — TIMESTAMP
승인 대기 (Untitled)
- a_id (Key) — UUID — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id
- status (Field) — ENUM('WATING', 'REJECT', 'ACCEPT')