Transcendence
Tables (8)
BannedUser
- id — INT — Primary key — NOT NULL
- channel (channel_id) — INT — Foreign key → Channel.id — NOT NULL
- user (user_id) — INT — Foreign key → User.id — NOT NULL
- until — DATETIME
Channel
- id — INT — Primary key — NOT NULL
- title — VARCHAR
- password — VARCHAR
- type — VARCHAR
Friend
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- followed_user_id — INT — Foreign key → User.id — NOT NULL
Match (Untitled)
- id — INt — Primary key — NOT NULL
- user_home — INT — Foreign key → User.id — NOT NULL
- user_foreign — INT — Foreign key → User.id — NOT NULL
- winner — INT — Foreign key → User.id — NOT NULL
- user_home_score — INT
- user_foreign_score — INT
- start_at — DATETIME
Message
- id — INT — Primary key — NOT NULL
- channel_id — INT — Foreign key → Channel.id — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- content — VARCHAR
- create_at — DATETIME
User
- id — INT — Primary key — NOT NULL
- user_name — VARCHAR
- password — VARCHAR
- e_mail — VARCHAR
- image_url — VARCHAR
- role_type — VARCHAR
UserChannel
- user_id — INT — Foreign key → User.id — NOT NULL
- channel_id — INT — Foreign key → Channel.id — NOT NULL
- is_owner — BOOLEAN