아동플랫폼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)