billiard
Tables (7)
Like
- PostId — int — Primary key — NOT NULL
- UserId — int — Primary key — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
Untitled (club)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (admin_name) — varchar(10) — NOT NULL
- Field (club_name) — varchar(20) — NOT NULL
- Field (address) — varchar(255) — NOT NULL
- Field (table) — tinyint — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (admin_id) — varchar(15) — NOT NULL
Untitled (match)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (score) — tinyint — NOT NULL
- Field (inning) — varchar(255)
- Field (highrun) — tinyint — NOT NULL
- Field (average)
comments
- id — int — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- UserId — int
- PostId — int
member (user)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (club_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (user_id) — varchar(15) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (nickname) — varchar(20) — NOT NULL
- Field (handy) — tinyint — NOT NULL
- Field (sns_id) — varchar(255)
- Field (provider) — varchar(10)
posts
- id — int — Primary key — NOT NULL
- content — text — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL
- UserId — int
- RetweetId — int — Foreign key → posts.id
users
- id — int — Primary key — NOT NULL
- email — varchar(30) — NOT NULL
- nickname — varchar(20) — NOT NULL
- password — varchar(100)
- avatar — varchar(255) — NOT NULL
- provider — varchar(10) — NOT NULL
- snsId — varchar(30)
- flag — tinyint(1) — NOT NULL
- createdAt — datetime — NOT NULL
- updatedAt — datetime — NOT NULL