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