sdorica

Tables (4)

characters

  • character_id — bigint — Primary key
  • image_url — varchar(255)
  • name — varchar(255)
  • position — varchar(255)
  • ranking — varchar(255)
  • skill_level — int

combination

  • combination_id — bigint — Primary key
  • gold_character_id — bigint — Foreign key → characters.character_id
  • gold_skill_book_id — bigint — Foreign key → skill_book.skill_book_id
  • title — varchar(255)
  • description — varchar(255)
  • white_character_id — bigint
  • white_skill_book_id — bigint
  • black_character_id — bigint
  • black_skill_book_id — bigint

posts

  • post_id — bigint — Primary key
  • combination_id — bigint — Foreign key → combination.combination_id
  • skill_book_id (skill_book_id2) — bigint — Foreign key → combination.gold_skill_book_id
  • created_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • modified_at — datetime(6) — NOT NULL
  • password — varchar(255)
  • writer — varchar(20)

skill_book

  • skill_book_id — bigint — Primary key
  • character_id — bigint — Foreign key → characters.character_id
  • name — varchar(255)
  • characters_id — bigint