5th_Practice

Tables (5)

books (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Key2) — VARCHAR(100) — NOT NULL
  • summary (Key3) — VARCHAR(1000) — NOT NULL
  • price (Key4) — INT — NOT NULL
  • author (Key5) — VARCHAR(50) — NOT NULL
  • createdAt (Key6) — DATE — NOT NULL

laptops (Untitled2)

  • name (Key2) — VARCHAR(100) — Primary key — NOT NULL
  • id (Key) — INT — NOT NULL
  • version (Key3) — FLOAT — NOT NULL
  • inch (Key5) — FLOAT — NOT NULL
  • price (Key6) — INT — NOT NULL
  • createdAt (Key7) — DATE — NOT NULL
  • stock (Key8) — INT — NOT NULL
  • menufacture_id (Key9) — INT — Foreign key → menufactures.id — NOT NULL

menufactures (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)

schools (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • city (Field2) — VARCHAR(100)

students (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • birth (Field2) — DATE
  • grade (Field4) — INT
  • class (Field5) — INT
  • mobile (Field6) — VARCHAR(500)
  • address (Field7) — VARCHAR(500)
  • school_id (Key2) — INT — Foreign key → schools.id — NOT NULL