트센

테이블 (9)

Achievement

  • achievement_id — Long — 기본 키 — NOT NULL
  • name — String
  • icon — String
  • description

ChannelMember

  • user_id — Long — 외래 키 → User.user_id — NOT NULL
  • channel_id — Long — 외래 키 → channel.channel_id — NOT NULL
  • role (owner, staff, member)

Chats

  • chat_id — Long — 기본 키 — NOT NULL
  • content — string
  • user_id — Long — 외래 키 → User.user_id — NOT NULL
  • channel_id — Long — 외래 키 → channel.channel_id — NOT NULL
  • date — LocaldateTime

Game

  • game_id — Long — 기본 키 — NOT NULL
  • date — LocaldateTime
  • user_id1 — Long — 외래 키 → User.user_id — NOT NULL
  • user_id22 — Long — 외래 키 → User.user_id — NOT NULL
  • winner_id — Long
  • type — Enum
  • mode — Enum

Relation

  • user_id1 — Long — 외래 키 → User.user_id — NOT NULL
  • user_id2 — Long — 외래 키 → User.user_id — NOT NULL
  • relationship — Enum

Untitled2

    User

    • user_id — Long — 기본 키 — NOT NULL
    • nick_name — Varchar(8)
    • is_second — boolean
    • gameList (Field) — List
    • relationList — List
    • avatar — String
    • point — int
    • win — int
    • lose — int

    UserAchievement

    • user_id — Long — 외래 키 → User.user_id — NOT NULL
    • achievement_id — Long — 외래 키 → Achievement.achievement_id — NOT NULL

    channel

    • channel_id — Long — 기본 키 — NOT NULL
    • title (Field) — String
    • mode — ENUM
    • total — Long
    • password — String