ktc assignment
Tables (3)
lv1schedule (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR(10)
- password (Field2) — VARCHAR(30)
- title (Field3) — VARCHAR(20)
- content (Field4) — VARCHAR(200)
- createdAt (Field5) — DATETIME
- modifiedAt (Field6) — DATETIME
lv3schedule (CopyOfUntitled)
- id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → lv3user.id — NOT NULL
- title (Field3) — VARCHAR(20)
- content (Field4) — VARCHAR(200)
- createdAt (Field5) — DATETIME
- modifiedAt (Field6) — DATETIME
lv3user (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(10)
- password (Field2) — VARCHAR(30)
- email (Field3) — VARCHAR(30)
- createdAt (Field4) — DATETIME
- modifiedAt (Field5) — DATETIME