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