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