5th_Practice

Tables (5)

books (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • summary (Field2) — VARCHAR(1000)
  • price (Field3) — INT
  • author (Field4) — VARCHAR(50)
  • createdAt (Field5) — DATE
  • stock (Field6) — DATE

laptops (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • version (Field2) — FLOAT
  • menufacture (Field3) — VARCHAR(100)
  • inch (Field4) — FLOAT
  • price (Field5) — INT
  • createdAt (Field6) — DATE
  • stock (Field7) — INT
  • menufacture_id (Key2) — INT — Foreign key → menufacture.id — NOT NULL

menufacture (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)
  • loc (Field2) — VARCHAR(100)

students (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • birth (Field2) — DATE
  • graed (Field4) — VARCHAR(100)
  • class (Field5) — INT
  • contact (Field6) — VARCHAR(100)
  • address (Field7) — VARCHAR(100)
  • school_id (Field3) — INT
  • id (Key2) — INT — Foreign key → schools.id — NOT NULL