kn_log
Tables (7)
Admin (Untitled2)
- admin_id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → User.user_id — NOT NULL
- center_id (Key2) — Foreign key → Center.center_id — NOT NULL
- is_primary_admin (Field) — 대표원장 여부 판단
Center (Untitled3)
- center_id (Key) — Primary key — NOT NULL
- created (Field)
- name (Field2)
- kind (Field3)
- type__name (Field4)
- phone (Field5)
- portal_center__code (Field6)
- address__country__alpha2 (Field7)
- address__state (Field8)
- address__city (Field9)
- status (Field10)
Child (Untitled4)
- child_id (Key) — Primary key — NOT NULL
- parent__user_id (Key2) — Foreign key → User.user_id — NOT NULL
- date_birth (Field)
- gender (Field2)
Devices (Untitled5)
- device_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → User.user_id — NOT NULL
- app_version (Field)
- os (Field2)
- push_type (Field3)
- last_login (Field4)
- last_logout (Field5)
Employment (Untitled6)
- employment_id (Key) — Primary key — NOT NULL
- teacher__user_id (Key2) — Foreign key → User.user_id — NOT NULL
- center_id (Key3) — Foreign key → Center.center_id — NOT NULL
- teacher_id (Field)
- is_approved (Field3)
- date_approved (Field2)
- date_left (Field4)
Enrollment (Untitled7)
- enrollment_id (Key) — Primary key — NOT NULL
- child_id (Key2) — Foreign key → Child.child_id — NOT NULL
- center_id (Key3) — Foreign key → Center.center_id — NOT NULL
- is_approved (Field)
- date_approved (Field2)
- date_left (Field3)
User (Untitled)
- user_id (Key) — Primary key — NOT NULL
- username (Field)
- type (Field2)
- date_joined (Field3)
- last_login (Field4)
- subscription_update_at (Field5)
- country__alpha2 (Field6)
- subscription (Field7)
- third_party_concent (Field8)