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