onj

Tables (7)

authority (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • name (Field)

content (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → user.id — NOT NULL
  • name (Field)

item (Untitled)

  • id (Key) — Primary key — NOT NULL
  • element (Field)
  • need_info (Field2)

template (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • content_id (Key3) — Foreign key → content.id — NOT NULL
  • name (Field)
  • template_type (Field3)
  • access_level (Field2)
  • in_use (Field5)
  • deleted (Field4)

template_item (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_item_id (Key2) — Foreign key → user_item.id — NOT NULL
  • template_id (Key3) — Foreign key → template.id — NOT NULL
  • answer (Field)

user (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)
  • name (Field3)

user_item (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • item_id (Key3) — Foreign key → item.id — NOT NULL
  • more_info (Field3)
  • deleted (Field4)