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)