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