BangBang

Tables (3)

PizzaScore (Untitled3)

  • id — BIGINT — Primary key — NOT NULL
  • toppingScore (topping_score) — INT
  • Score — INT
  • name — VARCHAR(50)

User (user)

  • id — Long — Primary key — NOT NULL
  • email — varchar(30)
  • password — varchar(255)
  • createdAt — TIMESTAMP
  • nickname — varchar(30)
  • status — VARCHAR(20)
  • lastLoginAt (last_login_at) — TIMESTAMP

UserScore (Untitled)

  • id — Long — Primary key — NOT NULL
  • userId — Long — Foreign key → User.id — NOT NULL
  • name — VARCHAR(50)
  • content — VARCHAR(200)
  • score — INT