JupJup
Tables (6)
Auth_Table (Untitled2)
- auth_Idx (Key) — Primary key — NOT NULL
- laptopSerialNumber (Key2) — VARCHAR — Foreign key → Laptop_Table.laptopSerialNumber — NOT NULL
- eqa_Idx (Key3) — LONG — Foreign key → Equipment_Allow_Table.eqa_Idx — NOT NULL
- email (Field) — VARCHAR
- password (Field2) — VARCHAR
- name (Field3) — VARCHAR
- classNumber (Field4) — VARCHAR
- create_at (Field5) — DATETIME
- authority (Field6) — ENUM
Equipment_Allow_Table (Untitled4)
- eqa_Idx (Key) — LONG — Primary key — NOT NULL
- eq_Idx (Key3) — LONG — Foreign key → Equipment_Table.eq_Idx — NOT NULL
- name (Field) — VARCHAR
- img (Field2) — VARBINARY
- amount (Field3) — INT
- status (Field4) — ENUM
- allow_at (Field5) — DATETIME
- reason (Field6) — VARCHAR
Equipment_Table (Untitled5)
- eq_Idx (Key) — LONG — Primary key — NOT NULL
- name (Field) — VARCHAR
- img (Field2) — VARBINARY
- content (Field3) — VARCHAR
- create_at (Field4) — DATETIME
- count (Field5) — INT
Laptop_Spec_Table (Untitled3)
- spec_Idx (Key) — LONG — Primary key — NOT NULL
- CPU (Field) — VARCHAR
- GPU (Field2) — VARCHAR
- RAM (Field3) — VARCHAR
- SSD (Field4) — VARCHAR
- HDD (Field5) — VARCHAR
Laptop_Table (Untitled)
- laptopSerialNumber (Key) — VARCHAR — Primary key — NOT NULL
- spec_Idx (Key2) — LONG — Foreign key → Laptop_Spec_Table.spec_Idx — NOT NULL
- laptopName (Field) — VARCHAR
- laptopbrand (Field2) — VARCHAR
- create_at (Field4) — DATETIME
Reservation_Table (Untitled6)
- reservation_Idx (Key3) — LONG — Primary key — NOT NULL
- auth_Idx (Key) — LONG — Foreign key → Auth_Table.auth_Idx — NOT NULL
- eqa_Idx (Key2) — LONG — Foreign key → Equipment_Allow_Table.eqa_Idx — NOT NULL
- reservation_Order (Field) — INT