Archive

Tables (4)

files (Untitled4)

  • Key — Primary key — NOT NULL
  • legacy_id (id) — int(11) — Foreign key → legacy.id — NOT NULL
  • storage_name (Field) — VARCHAR(40)
  • origin_name (Field2) — TEXT
  • path (Field3) — TEXT
  • volume (Field4) — int(50)

legacy (Untitled2)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (Key2) — int(11) — Foreign key → users.id — NOT NULL
  • created (Field) — DATETIME
  • class (Field2) — int(4)
  • author (Field3) — VARCHAR(30)
  • birth (Field4) — DATETIME
  • updated (Field5) — DATETIME
  • mime (Field6) — VARCHAR(30)
  • explanation (Field7) — TEXT

tags (Untitled3)

  • id (Key) — int(11) — Primary key — NOT NULL
  • legacy_id (Key2) — int(11) — Foreign key → legacy.id — NOT NULL
  • name (Field) — VARCHAR(30)

users (Untitled)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (Field) — VARCHAR(30)
  • password (Field2) — VARCHAR(100)
  • name (Field7) — VARCHAR(30)
  • class (Field3) — VARCHAR(30)
  • created (Field4) — DATETIME
  • updated (Field5) — TIMESTAMP
  • disabled (Field6) — CHAR