[PM] New Device ERD

Tables (4)

BlockData (Untitled3)

  • block_data_id (Key) — Primary key — NOT NULL
  • device_id (Key2) — Foreign key → Device.device_id — NOT NULL
  • s1 -> s12 (Field2)
  • datetime (Field3)

Device (Untitled2)

  • device_id (Key) — Primary key — NOT NULL
  • type_id (Key2) — Foreign key → DeviceType.id — NOT NULL
  • member_id (Key3) — Foreign key → Member.member_id — NOT NULL

DeviceType (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • type (Field2)
  • count (Field)

Member (Untitled)

  • member_id (Key) — Primary key — NOT NULL
  • login_id (Field)
  • password (Field2)