pittalk
Tables (5)
comment
- id — BIGINT(20) — Primary key — NOT NULL
- post_id — BIGINT(20)
- user_id — BIGINT(20)
- content — VARCHAR(255)
- created_at — DATETIME
post
- id — BIGINT(20) — Primary key — NOT NULL
- team_id — BIGINT(20)
- user_id — BIGINT(20)
- title — VARCHAR(255)
- content — VARCHAR(255)
- like_count — INT(11)
- created_at — DATETIME
team
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(255)
- intro_text — VARCHAR(255)
team_trait
- id — BIGINT(20) — Primary key — NOT NULL
- team_name — VARCHAR(255)
- performance — INT(11)
- tradition — INT(11)
- tech_vs_emotion — INT(11)
- underdog — INT(11)
- budget — INT(11)
- driver — INT(11)
user
- id — BIGINT(20) — Primary key — NOT NULL
- userid — VARCHAR(255)
- password — VARCHAR(255)
- nickname — VARCHAR(255)
- favorite_team_id — BIGINT(20)