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