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