SAIFE

Tables (4)

UserContactInfo (Untitled)

  • id (Key) — BIGINT(10) — Foreign key → VocUser.id — NOT NULL
  • contact_type (Field) — VARCHAR(50) — NOT NULL
  • contact_info (Field2) — VARCHAR(50) — NOT NULL

VocItem (Untitled2)

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • user_id (Key2) — BIGINT(10) — Foreign key → VocUser.id — NOT NULL
  • subject (Field) — VARCHAR(50) — NOT NULL
  • date (Field2) — DATETIME — NOT NULL
  • Field3
  • Field4

VocKeyword (Untitled3)

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • key (Field) — VARCHAR(20) — NOT NULL
  • value (Field2) — VARCHAR(20) — NOT NULL

VocUser

  • id (Key) — BIGINT(10) — Primary key — NOT NULL
  • username (Field) — VARCHAR(50) — NOT NULL
  • name (Field2) — VARCHAR(50) — NOT NULL