tanscendence

Tables (9)

Achievement

  • achievement_id — Long — Primary key — NOT NULL
  • Name (name) — String
  • Icon (icon) — String
  • description

Channel (channel)

  • channel_id — Long — Primary key — NOT NULL
  • title (Field) — String
  • mode — ENUM
  • total — Long
  • password — String

ChannelMember

  • user_id — Long — Foreign key → User.user_id — NOT NULL
  • channel_id — Long — Foreign key → Channel.channel_id — NOT NULL
  • role (Owner, Staff, Member)

Chats

  • chat_id — Long — Primary key — NOT NULL
  • content — string
  • user_id — Long — Foreign key → User.user_id — NOT NULL
  • channel_id — Long — Foreign key → Channel.channel_id — NOT NULL
  • date — LocaldateTime

Game

  • game_id — Long — Primary key — NOT NULL
  • date — LocaldateTime
  • user_id1 — Long — Foreign key → User.user_id — NOT NULL
  • user_id2 (user_id22) — Long — Foreign key → User.user_id — NOT NULL
  • winner_id — Long
  • type — Enum
  • mode — Enum

Relationship (Relation)

  • user_id1 — Long — Foreign key → User.user_id — NOT NULL
  • user_id2 — Long — Foreign key → User.user_id — NOT NULL
  • relationship — Enum

Untitled2

    User

    • user_id — Long — Primary key — NOT NULL
    • nickNmae (nick_name) — Varchar(8)
    • isSecond (is_second) — boolean
    • gameList (Field) — List
    • relationList — List
    • avatar — String
    • point — Long

    UserAchievement

    • user_id — Long — Foreign key → User.user_id — NOT NULL
    • achievement_id — Long — Foreign key → Achievement.achievement_id — NOT NULL
    • date — LocalDateTime