ㅇㅇ
Tables (6)
GAME_REVIEW
- app_id — BIGINT — Primary key — NOT NULL
- review_id — INT — Primary key — NOT NULL
- review_text — TEXT
REVIEW_TAG
- app_id — BIGINT — Primary key — NOT NULL
- review_id — INT — Primary key — NOT NULL
- game — INT — NOT NULL
- story — INT — NOT NULL
- graphics — INT — NOT NULL
- sound — INT — NOT NULL
- content — INT — NOT NULL
- originality — INT — NOT NULL
- stability — INT — NOT NULL
- convenience — INT — NOT NULL
SIMILAR_GAMES
- game_app_id — BIGINT — Primary key — NOT NULL
- recommended_app_id — BIGINT — Primary key — NOT NULL
- user_tags — JSON
TAGS
- tag_id — INT — Primary key
- tag_name — VARCHAR(255) — NOT NULL
TITLELIST
- app_id — BIGINT — Primary key — NOT NULL
- start_date — DATETIME — Primary key — NOT NULL
- name — VARCHAR(255)
- user_tags — TEXT
- price_us — FLOAT
- releaseYear — VARCHAR(10)
- userScore — FLOAT
TOPINDIMOBA_GAME
- app_id — BIGINT — Primary key — NOT NULL
- start_date — DATETIME — Primary key — NOT NULL