GW
Tables (6)
keyword
- keyword_name — VARCHAR(50) — Primary key — NOT NULL
- user_account_id — VARCHAR(50) — Foreign key → user.user_account_id — NOT NULL
- update_date — DATETIME — Foreign key → user.update_date — NOT NULL
- keyword_count — INT
label
- label_name — VARCHAR(100) — Primary key — NOT NULL
- user_account_id — VARCHAR(50) — Foreign key → user.user_account_id — NOT NULL
- update_date — DATETIME — Foreign key → user.update_date — NOT NULL
- mail_count — INT
mail
- mail_id — VARCHAR(200) — Primary key — NOT NULL
- label_name (label_name2) — VARCHAR(100) — Foreign key → label.label_name — NOT NULL
- user_account_id — VARCHAR(50) — Foreign key → label.user_account_id — NOT NULL
- update_date — DATETIME — Foreign key → label.update_date — NOT NULL
- label_name — VARCHAR(100)
person
- person_account_id — VARCHAR(50) — Primary key — NOT NULL
- user_account_id — VARCHAR(50) — Foreign key → user.user_account_id — NOT NULL
- update_date — DATETIME — Foreign key → user.update_date — NOT NULL
- person_name — VARCHAR(20)
- receive_mails — INT
- send_mails — INT
- friendly_mails — INT
query
- query_id — CHAR(36) — Primary key — NOT NULL
- user_account_id — VARCHAR(50) — Foreign key → user.user_account_id — NOT NULL
- update_date — DATETIME — Foreign key → user.update_date — NOT NULL
- context — TEXT
user
- user_account_id — VARCHAR(50) — Primary key — NOT NULL
- update_date — DATETIME — Primary key — NOT NULL
- index_time — VARCHAR(50)
- my_mail_count — INT