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