game_community

Tables (9)

Comments

  • comment_id — BigInt — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.user_id — NOT NULL
  • post_id — BigInt — Foreign key → Posts.post_id — NOT NULL
  • contents — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL

Friends

  • user_id — BigInt — NOT NULL
  • friend_id — BigInt — NOT NULL
  • state — VARCHAR — NOT NULL

GroupUsers

  • group_id — BigInt — NOT NULL
  • user_id — BigInt — NOT NULL

GuestBook

  • userComment_id — BigInt — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.user_id — NOT NULL
  • author — VARCHAR — NOT NULL
  • ration — Integer — NOT NULL
  • comment — VARCHAR — NOT NULL
  • created_at — TIMESTAMP
  • modifited_at — TIMESTAMP

PostLikes

  • post_like_id — BigInt — Primary key — NOT NULL
  • post_id — BigInt — Foreign key → Posts.post_id — NOT NULL
  • user_id — BigInt — Foreign key → Posts.user_id — NOT NULL
  • is_like — BOOLEAN — NOT NULL

Posts

  • post_id — BigInt — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.user_id — NOT NULL
  • post_title — VARCHAR — NOT NULL
  • post_content — VARCHAR(500) — NOT NULL
  • post_author — VARCHAR — NOT NULL
  • post_image_url — VARCHAR
  • post_complaint — Integer — NOT NULL — default = 0
  • post_like — Integer — NOT NULL
  • post_unlike — Integer — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • game_type — VARCHAR
  • game_name — VARCHAR
  • board_name — VARCHAR — NOT NULL

Report

  • report — BigInt — Primary key — NOT NULL
  • post_id — BigInt — Foreign key → Posts.post_id — NOT NULL
  • user_id — BigInt — Foreign key → Posts.user_id — NOT NULL

Teams

  • id — BigInt — Primary key — NOT NULL
  • name — VARCHAR — NOT NULL
  • introduction — VARCHAR
  • created_at — TIMESTAMP — NOT NULL
  • modified_at — TIMESTAMP — NOT NULL
  • game_name — varchar — NOT NULL
  • admin_id — Integer — NOT NULL

Users

  • user_id — BigInt — Primary key — NOT NULL
  • profile_url — VARCHAR
  • email — VARCHAR — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL
  • introduction — VARCHAR
  • block_date — TIMESTAMP
  • ranking — Integer — NOT NULL