5th_Practice

Tables (5)

books (Untitled)

  • id (Key) — Primary key — NOT NULL
  • title (Key2) — VARCHAR(100) — Primary key — NOT NULL
  • summary (Key3) — VARCHAR(1000) — Primary key — NOT NULL
  • price (Field) — INT
  • author (Field2) — VARCHAR(50)
  • create\At (Field3)

laptops (Untitled2)

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

menufactures (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • Field
  • id (Key2) — INT — Foreign key → laptops.id — NOT NULL

schools (Untitled5)

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

students (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • birth (Field2) — DATE
  • school (Field3) — VARCHAR(100)
  • grade (Field4) — VARCHAR(100)
  • class (Field5) — VARCHAR(50)
  • address (Field6) — VARCHAR(50)
  • phone_number (Field7) — VARCHAR(50)
  • Field8