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