NGS
Tables (25)
Bundle
- id — BIGINT
- bundle_name — VARCHAR(255)
- discount_rate — DECIMAL(5,2)
Bundled_Game_List
- game_id — BIGINT
- bundle_id — BIGINT
Cart
- id — BIGINT
- user_id — BIGINT
- game_id — BIGINT
Community
- id — BIGINT
- game_id — BIGINT
- title — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CommunityComment
- id — BIGINT
- post_id — BIGINT
- writer — BIGINT
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CommunityPost
- id — BIGINT
- title — VARCHAR(255)
- writer — BIGINT
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CommunitySubscriber
- user_id — BIGINT
- game_id — BIGINT
Follow
- user_id — BIGINT
- publisher_id — BIGINT
- game_id — BIGINT
Game
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10,2)
- is_discounted — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_active — BOOLEAN
- description — TEXT
- info — TEXT
- publisher_id — BIGINT
- status — INT
GameNotice
- id — BIGINT
- game_id — BIGINT
- title — VARCHAR(255)
- content — TEXT
- category — INT
- created_at — TIMESTAMP
GameTag
- id — BIGINT
- parent_tag — BIGINT
- name — VARCHAR(100)
LinkedEnvs
- game_id — BIGINT
- env_id — INT
LinkedTags
- game_id — BIGINT
- tag_id — BIGINT
Media
- id — BIGINT
- category — VARCHAR(50)
- file_url — VARCHAR(255)
- user_id — BIGINT
- game_id — BIGINT
- created_at — TIMESTAMP
Order
- id — BIGINT
- user_id — BIGINT
- game_id — BIGINT
- statement — INT
- price_snapshot — DECIMAL(10,2)
- is_refundable — BOOLEAN
- created_at — TIMESTAMP
OrderHistory
- id — BIGINT
- order_id — BIGINT
- from_state — INT
- to_state — INT
- created_at — TIMESTAMP
Payment
- id — BIGINT
- user_id — BIGINT
- order_id — BIGINT
- method — INT
- amount — DECIMAL(10,2)
- status — VARCHAR(50)
- transaction — VARCHAR(255)
- info — TEXT
- created_at — TIMESTAMP
- paid_at — TIMESTAMP
- cancelled_at — TIMESTAMP
Review
- id — BIGINT
- user_id — BIGINT
- game_id — BIGINT
- created_at — TIMESTAMP
- content — TEXT
- score — INT
SingleGameDiscount
- game_id — BIGINT
- is_active — BOOLEAN
- discount_rate — DECIMAL(5,2)
- created_at — TIMESTAMP
- expired_at — TIMESTAMP
Support
- id — BIGINT
- user_id — BIGINT
- order_id — BIGINT
- category — BIGINT
- status — INT
- content — TEXT
- created_at — TIMESTAMP
SupportAnswer
- id — BIGINT
- support_id — BIGINT
- created_at — TIMESTAMP
- content — TEXT
SupportCategory
- id — BIGINT
- parent_cat_id — BIGINT
- name — VARCHAR(100)
- description — TEXT
User (Untitled)
- id — number — Primary key
- name — varchar(50)
- nickname — varchar(50)
- email — varchar(50)
- password — varchar(50)
- oauth — varchar(50)
- birth_at — varchar(50)
- created_at — timestamp
- deleted_at — timestamp
- is_active — boolean
- statement — varchar(20)
- role — varchar(20)
User
- id — BIGINT
- name — VARCHAR(100)
- nickname — VARCHAR(100)
- email — VARCHAR(255)
- pwd — VARCHAR(255)
- oauth — VARCHAR(100)
- birth_at — DATE
- created_at — TIMESTAMP
- deleted_at — TIMESTAMP
- is_active — BOOLEAN
- statement_id — INT
- role_id — INT
User Role (Untitled2)
- user — varchar(10)
- admin — varchar(10)
- publisher — varchar(10)