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)