GDG

Tables (7)

Chat (Untitled6)

  • chat_id (Key) — Long — Primary key — NOT NULL
  • text (Field3) — TEXT
  • is_todo (Field4) — Boolean
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • team_id (Key3) — Long — Foreign key → Team.team_id — NOT NULL

Report (Untitled5)

  • report_id (Key) — Long — Primary key — NOT NULL
  • title (Field3) — String
  • text (Field4) — TEXT
  • location (Field5) — String
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL

Team (Untitled3)

  • team_id (Key) — Long — Primary key — NOT NULL
  • name (Field3) — String
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime

Translation (Untitled8)

  • translation_id (Key) — Long — Primary key — NOT NULL
  • text (Field) — TEXT
  • language (Field4) — Enum
  • created_at (Field2) — LocalDateTime
  • updated_at (Field3) — LocalDateTime
  • chat_id (Key2) — Long — Foreign key → Chat.chat_id — NOT NULL

User (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • login_id (Field) — String
  • email (Field8) — String
  • password (Field2) — String
  • name (Field7) — String
  • language (Field3) — Enum
  • role (Field6) — Enum
  • oauth_provider (Field9) — Enum
  • oauth_id (Field10) — String
  • created_at (Field4) — LocalDateTime
  • updated_at (Field5) — LocalDateTime

User_Team (Untitled4)

  • user_team_id (Key) — Long — Primary key — NOT NULL
  • access_date (Field3) — LocalDateTime
  • unReadMessage (Field4) — int
  • inRoom (Field5) — Boolean
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime
  • user_id (Key2) — Long — Foreign key → User.id — NOT NULL
  • team_id (Key3) — Long — Foreign key → Team.team_id — NOT NULL

Word (Untitled9)

  • word_id (Key) — Long — Primary key — NOT NULL
  • image_url (Field) — String
  • original (Field2) — String
  • correction (Field3) — String
  • translation (Field4) — String
  • created_at (Field5) — LocalDateTime
  • updated_at (Field6) — LocalDateTime
  • chat_id (Key2) — Long — Foreign key → Chat.chat_id — NOT NULL