fsadsad

Tables (7)

Untitled (file_status)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (removed) — INTEGER
  • Field (shared) — INTEGER
  • Field (hidden) — INTEGER

Untitled (groups)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)

Untitled (users)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field (nickname) — VARCHAR(20)
  • Field (password) — VARCHAR(30)
  • Field (group_id) — INTEGER

Untitled (file_attribute)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Field (user_id) — INTEGER

Untitled (file_custom_attribute)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Key (file_status_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Key (id2) — INTEGER — Foreign key → Untitled.Key — NOT NULL

Untitled2 (file_display_attribute)

  • Key (id) — INTEGER — Primary key
  • Key (file_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(255)
  • Field (extension) — VARCHAR(255)
  • Field (size) — INTEGER
  • Field (created_date) — DATETIME
  • Field (modified_date) — DATETIME
  • Field (accessed_date) — DATETIME

file_mapper (file_path_mapper)

  • Key (id) — INTEGER — Primary key — NOT NULL
  • Key (file_id) — INTEGER — Foreign key → Untitled.Key — NOT NULL
  • Field (physical_path) — VARCHAR(255)
  • Field (logical_path) — VARCHAR(255)
  • Field (parent_file_id) — INTEGER