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
laptops (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- name (Key2) — VARCHAR(100) — Primary key — NOT NULL
- version (Field) — FLOAT
- inch (Field3) — FLOAT
- price (Field4) — INT
- createdAt (Field5) — DATE
- stock (Field6) — INT
- meufacture_id (Key3) — INT — Foreign key → meufactures.id — NOT NULL
meufactures (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(50)
students (Untitled4)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- birth (Field2) — DATE
- grade (Field4) — INT
- class (Field5) — INT
- number (Field6) — VARCHAR(20)
- address (Field7) — VARCHAR(200)
- school_id (Key2) — INT — Foreign key → schools.id — NOT NULL