pick-kasso

Tables (8)

User (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • sns_id (Field) — bigint
  • nickname (Field2) — varchar(10)
  • sns_platform (Field3) — varchar(20)

curriculum (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • title (Field) — varchar(20)
  • curriculum_explanation (Field2) — varchar(1000)
  • round_count (Field3) — int
  • difficulty (Field4) — varchar(10)

curricuum_background (Untitled7)

  • id (Key) — bigint — Foreign key → curriculum.id — NOT NULL
  • background_link (Field) — varchar(100)

painting (Untitled8)

  • user_id (Key) — bigint — Foreign key → User.id — NOT NULL
  • id (Key2) — bigint — Foreign key → round.id — NOT NULL
  • created_at (Field) — date
  • title (Field2) — varchar(20)
  • state (Field3) — boolean

profile_picture (Untitled2)

  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • profile_link (Field) — varchar(100)

round (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • curriculum_id (Key2) — bigint — Foreign key → curriculum.id — NOT NULL
  • round_order (Field) — int
  • round_time (Field2) — char(8)
  • round_explanation (Field3)

user_curriculum (Untitled6)

  • user_id (Key) — bigint — Foreign key → User.id — NOT NULL
  • curriculum_id (Key2) — bigint — Foreign key → curriculum.id — NOT NULL
  • state (Field) — boolean

user_round (Untitled3)

  • user_id (Key) — bigint — Foreign key → User.id — NOT NULL
  • round_id (Key2) — bigint — Foreign key → round.id — NOT NULL
  • progress_state (Field) — boolean