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