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