jdt

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 (Untitled3)

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

curriculum_background (Untitled4)

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

painting (Untitled2)

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

profile_picture (Untitled8)

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

round (Untitled6)

  • id (Key2) — bigint — Primary key — NOT NULL
  • curriculum_id (Key) — bigint — Foreign key → curriculum.id — NOT NULL
  • round_order (Field) — int
  • round_time (Field2) — cahr(8)
  • explanation (Field4) — varchar(30)
  • Field5
  • painting_id (Key3) — bigint — Foreign key → painting.id — NOT NULL

user-curriculum (Untitled5)

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

user_round (Untitled7)

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