아동플랫폼ERD(1)

테이블 (10)

ATTENDANCES (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • program_id? (Key2) — 외래 키 → ENROLLMENTS.id — NOT NULL
  • enrollment_id (Key22) — 외래 키 → ENROLLMENTS.program_id — NOT NULL
  • session_id (Key3) — 외래 키 → PROGRAM_SESSION.id — NOT NULL
  • is_present (Field)
  • marked_by (Field2)
  • marked_at (Field3)
  • created_at (Field4)
  • updated_at (Field5)

CENTER_USERS (Untitled3)

  • id (Key) — 외래 키 → USERS.id — NOT NULL
  • center_name (Field)
  • phone (Field2)
  • address (Field3)
  • website (Field4)
  • latitude (Field5)
  • longitude (Field6)
  • is_verified (Field7)
  • status (Field8)
  • incative_date (Field9)

ENROLLMENTS (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • program_id (Key2) — 외래 키 → PROGRAMS.id — NOT NULL
  • member_id (Key3) — 외래 키 → Member_Users.id — NOT NULL
  • status (Field) — enum
  • applied_at (Field2)
  • updated_at (Field3)

Member_Users (Untitled2)

  • id (Key) — 외래 키 → USERS.id — NOT NULL
  • child_name (Field)
  • guardian_name (Field2)
  • phone (Field3)
  • address (Field4)
  • detail_address (Field5)
  • latitude (Field6)
  • longitude (Field7)
  • gender (enum)
  • status (Field8)
  • inactive_date (Field9) — datetype

PROGRAMS (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • center_id (Key2) — 외래 키 → CENTER_USERS.id — NOT NULL
  • program_name (Field)
  • activity_type (Field2) — enum
  • description (Field3)
  • link (Field4)
  • total_session (INT)
  • status (Field5)
  • created_at (Field6)
  • updated_at (Field7)

PROGRAM_SESSION (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • program_id (Key2) — 외래 키 → PROGRAMS.id — NOT NULL
  • session_number (Field)
  • session_date (Field2)
  • start_time (Field3)
  • end_time (Field4)
  • is_completed (Field5) — Boolean
  • created_at (Field6)
  • updated_at (Field7)

REPORT_IMAGES (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • report_id (Key2) — 외래 키 → SESSION_REPORTS.id — NOT NULL
  • image_url (Field)
  • display_order (Field2)
  • created_at (Field3)

SESSION_REPORTS (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • sesson_id (Key2) — 외래 키 → PROGRAM_SESSION.id — NOT NULL
  • description (Field)
  • created_by (Field2)
  • created_at (Field3)
  • updated_at (Field4)

USERS (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • email (Field)
  • password (Field2) — enum
  • user_type (Field3) — enum
  • created_at (Field4)
  • refresh_token (Field5)
  • lastloginat (Field6)

alarm (Untitled10)