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