ian

Tables (7)

admin

  • id — INT — Primary key — NOT NULL
  • auth_id — VARCHAR(100) — NOT NULL
  • deleted — INT — NOT NULL

input_setting

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_modified — INT — NOT NULL
  • type — VARCHAR(100) — NOT NULL
  • type_modified — INT — NOT NULL
  • data — JSON — NOT NULL
  • deleted — INT — NOT NULL

tool

  • id — INT — Primary key — NOT NULL
  • user_tool_set_id — INT — Foreign key → user_tool_set.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_modified — INT — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • url_modified — INT — NOT NULL
  • deleted — INT — NOT NULL

user

  • id — INT — Primary key — NOT NULL
  • group_id — INT — Foreign key → user_group.id — NOT NULL
  • auth_id — VARCHAR(100) — NOT NULL
  • group_id_modified — INT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_modified — INT — NOT NULL
  • deleted — INT — NOT NULL

user_group

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • name_modified — INT — NOT NULL
  • deleted — INT — NOT NULL

user_tag

  • id — INT — Primary key — NOT NULL
  • tag — VARCHAR(100) — NOT NULL
  • tag_modified — INT — NOT NULL
  • deleted — INT — NOT NULL

user_tool_set

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • order — INT — NOT NULL
  • order_modified — INT — NOT NULL
  • deleted — INT — NOT NULL