AGORA

Tables (24)

Asset Store Reviews (assetStoreReviews)

  • ID (id) — uuid — Primary key — NOT NULL
  • Asset Store Board ID (assetsToreBoardId) — uuid — Foreign key → AssetStore Board.ID — NOT NULL
  • Writer ID (writerId) — uuid — Foreign key → Users.ID — NOT NULL
  • Rating (rating) — number — NOT NULL — 별점
  • Description (description) — string

AssetStore Board (assetStoreBoards)

  • ID (id) — uuid — Primary key — NOT NULL
  • autor (authorId) — uuid — Foreign key → Users.ID — NOT NULL
  • Title (title) — string — NOT NULL
  • Description (description) — string — NOT NULL
  • Price (price) — number — NOT NULL
  • Download URL (downloadURL) — string[] — NOT NULL

CategoryType Board relation (developer-community-categoryTypeBoard Relation)

  • ID (id) — varchar — Foreign key → Developer Community Boards.ID — NOT NULL
  • ID (CategoryTypeId) — varchar — Foreign key → developer-community-categoryTypes.ID — NOT NULL

Cost (Untitled3)

  • ID (id) — uuid — Primary key — NOT NULL
  • GameStore ID (gameStoreId) — uuid — Foreign key → Games.id — NOT NULL
  • Is Free (isFree) — boolean
  • Defaault Price (defaultPrice) — number
  • Is Sale (isSale) — boolean
  • Sale Percentage (salePercentage) — number
  • Sale Price (salePrice) — number
  • Sale Start Date (saleStartAt) — Date
  • Sale End Date (saleEndAt) — Date

Developer Community Boards (developer-community-boards)

  • ID (id) — varchar — Primary key — NOT NULL
  • writerId — varchar — Foreign key → Users.ID — NOT NULL — join to column
  • Parent Id (parentId) — uuid — Foreign key → Developer Community Boards.ID
  • createdAt — Date — NOT NULL
  • updatedAt — Date — NOT NULL
  • Child Count (childCount) — int — NOT NULL — while(parent != null) parent.childNum +1 parent = parent.parent For fast loading
  • Title (title) — varchar — NOT NULL
  • Content (content) — varchar(4000) — NOT NULL
  • View (view) — int — NOT NULL
  • Like Count (likeCount) — number

Developer Community Like Relation (developer-community-likeRelation)

  • Board ID (boardId) — varchar — Foreign key → Developer Community Boards.ID — NOT NULL
  • User Id (userId) — varchar — Foreign key → Users.ID — NOT NULL

Game Board CategoryTypes (gameBoardCategoryTypes)

  • Id (id) — uuid — Primary key — NOT NULL
  • Name (name) — string — NOT NULL

Game Boards (game-boards)

  • id (Id) — varchar — Primary key — NOT NULL
  • Writer Id (writerId) — varchar — Foreign key → Users.ID — NOT NULL
  • Game Id (gameId) — varchar — Foreign key → Games.id — NOT NULL
  • Parent Id (parentId) — varchar — Foreign key → Game Boards.id — NOT NULL
  • Title (title) — varchar
  • Content (content) — varchar
  • Like (like) — number
  • Child (child)

Game Boards Category Types Relations (gameBoardsCategoryTypesRelations)

  • Id (id) — uuid — Foreign key → Game Board CategoryTypes.Id — NOT NULL
  • id (Id) — varchar — Foreign key → Game Boards.id — NOT NULL

Game Genre Relations (Game-Genre-Relations)

  • Id (Key) — Foreign key → Genre.ID — NOT NULL
  • id (Id) — varchar — Foreign key → Games.id — NOT NULL

Game Like Relations (gameLikeRelations)

  • User ID (userId) — uuid — Foreign key → Users.ID — NOT NULL
  • Game ID (gameId) — uuid — Foreign key → Games.id — NOT NULL

Game Playtime Relations (Game Playtime Relation)

  • ID (id) — uuid — Primary key — NOT NULL
  • User ID (UserId) — uuid — Foreign key → Users.ID — NOT NULL
  • Game ID (gameId) — uuid — Foreign key → Games.id — NOT NULL
  • Playtime (playtime) — number

Game Review Comment (Untitled4)

  • ID (id) — string — Primary key — NOT NULL
  • Content (Field)

Game Reviews (Untitled)

  • ID (id) — uuid — Primary key — NOT NULL
  • Writer ID (writerId) — varchar — Foreign key → Users.ID — NOT NULL
  • Game ID (gameId) — varchar — Foreign key → Games.id — NOT NULL
  • Content (content) — varchar — NOT NULL
  • Like Count (likeCount) — number — NOT NULL
  • Unlike Count (unlikeCount) — number — NOT NULL

Game Reviews Like Relations (Untitled2)

  • ID (Id) — uuid — Primary key — NOT NULL
  • User ID (userId) — uuid — Foreign key → Users.ID — NOT NULL
  • Review ID (reviewId) — uuid — Foreign key → Game Reviews.ID — NOT NULL
  • action (Field) — 'like' | 'unlike'|null

Game Store Board Like Relation (game-store-board-ikeRelation)

  • User Id (userId) — varchar — Foreign key → Users.ID — NOT NULL
  • Board Id (boardId) — varchar — Foreign key → Game Boards.id — NOT NULL

Game Tag Relations (Untitled5)

  • Tag ID (tagId) — uuid — Foreign key → GameTag.ID — NOT NULL
  • User ID (userId) — uuid — Foreign key → Users.ID — NOT NULL
  • Game ID (gameId) — uuid — Foreign key → Games.id — NOT NULL

GameTag (Untitled6)

  • ID (id) — uuid — Primary key — NOT NULL
  • Name (name) — string

Games (games)

  • id (Id) — uuid — Primary key — NOT NULL
  • authorId (Author Id) — uuid — Foreign key → Users.ID — NOT NULL
  • Title (title) — varchar
  • Description (description) — varchar
  • DownloadUrl (downloadUrl) — varchar
  • Banner Image Urls (bannerImageUrls) — array<string>
  • Like Count (likeCount) — number
  • SNS links (snsLinks) — array<string>
  • ShortDescription (shortDescription) — array<string>

Genre

  • ID (id) — uuid — Primary key — NOT NULL
  • Name (name) — string

SNS URLs (SNSUrls)

  • ID (id) — uuid — Primary key — NOT NULL
  • Game Store Id (gameStoreId) — uuid — Foreign key → Games.id — NOT NULL
  • Youtube (youtube) — string
  • Twitch (twitch) — string
  • Discord (discord) — string
  • Custom Page (customPage) — string

Short Description (shortDescription)

  • ID (id) — uuid — Primary key — NOT NULL
  • Game Store ID (gameStoreId) — uuid — Foreign key → Games.id — NOT NULL
  • Image Url (imageUrl) — string
  • Content (content) — string

Users

  • ID (id) — uuid — Primary key — NOT NULL
  • Name (name) — varchar — NOT NULL
  • createdAt — Date — NOT NULL
  • Description (description) — varchar
  • Rating (rating) — number — NOT NULL
  • Token (token) — int — NOT NULL
  • Field

developer-community-categoryTypes (Developer Community Category Types)

  • ID (id) — varchar — Primary key — NOT NULL
  • Name (name) — varchar — NOT NULL