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