Capstone_Client
bletcher erd prev ver
Tables (4)
Untitled (User)
- Key (id) — int — Primary key — NOT NULL
- Field (username) — varchar — NOT NULL
- Field (password) — varchar — NOT NULL
- Field2 (device_cnt) — int
Untitled (Notice)
- Key (id) — int(11) — Primary key — NOT NULL
- Key (device_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (is_readed) — tinyint — NOT NULL
- Field (created_at) — timestamp — NOT NULL
Untitled (Device)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field2 (trap_id) — varchar — NOT NULL
- Field (location) — varchar — NOT NULL
- Field (region) — varchar — NOT NULL
- Field (is_replacement) — tinyint
- Field (is_error) — tinyint
- Field (created_at) — timestamp — NOT NULL
- Field (type\)
Untitled (err_Detail)
- Key (device_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (code) — varchar
- Field (last_transmission_time) — date — NOT NULL
- Field (is_expired) — tinyint — NOT NULL