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

Untitled2

    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