shout

Tables (3)

account

  • account_id — INT — Primary key
  • username — VARCHAR(255)
  • password — CHAR(60) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • cop_name — VARCHAR(255)
  • tenure — INT
  • position — TEXT
  • create_time — TIMESTAMP
  • update_time — TIMESTAMP

context

  • context_id — INT — Primary key — NOT NULL
  • account_id (account_id2) — INT — Foreign key → account.account_id
  • summary — VARCHAR(36) — NOT NULL
  • create_time — TIMESTAMP — NOT NULL

message

  • message_id — INT — Primary key — NOT NULL
  • account_id (account_id2) — INT — Foreign key → account.account_id
  • context_id (context_id2) — INT — Foreign key → context.context_id — NOT NULL
  • is_user — TINYINT — NOT NULL
  • content — TEXT — NOT NULL
  • create_time — TIMESTAMP — NOT NULL