test

Tables (3)

StudyGroup (Untitled2)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • teacherId (Key2) — VARCHAR(60) — Foreign key → User.id — NOT NULL
  • title (Field) — VARCHAR(60)
  • content (Field2) — VARCHAR(60)
  • Field3

User (Untitled)

  • id (Key) — VARCHAR(60) — Primary key — NOT NULL
  • pw (Field) — VARCHAR(60)
  • phone (Field2) — VARCHAR(12)
  • Field3

User_Study (Untitled3)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userId (Key2) — VARCHAR(60) — Foreign key → User.id — NOT NULL
  • groupId (Key3) — INTEGER — Foreign key → StudyGroup.id — NOT NULL
  • id (Key22) — VARCHAR(60) — Foreign key → StudyGroup.teacherId — NOT NULL
  • Field2