ktc assignment

Tables (3)

lv1schedule (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR(10)
  • password (Field2) — VARCHAR(30)
  • title (Field3) — VARCHAR(20)
  • content (Field4) — VARCHAR(200)
  • createdAt (Field5) — DATETIME
  • modifiedAt (Field6) — DATETIME

lv3schedule (CopyOfUntitled)

  • id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → lv3user.id — NOT NULL
  • title (Field3) — VARCHAR(20)
  • content (Field4) — VARCHAR(200)
  • createdAt (Field5) — DATETIME
  • modifiedAt (Field6) — DATETIME

lv3user (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(10)
  • password (Field2) — VARCHAR(30)
  • email (Field3) — VARCHAR(30)
  • createdAt (Field4) — DATETIME
  • modifiedAt (Field5) — DATETIME