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')