tourun erd2
Tables (6)
course
- course_id — int — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
review
- id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- user_course_id — int — Primary key — NOT NULL
- rating — int — NOT NULL
- id2 — int — Foreign key → user_course.id — NOT NULL
- user_id2 — int — Foreign key → user_course.user_id — NOT NULL
- course_id2 — VARCHAR(255) — Foreign key → user_course.course_id
user
- id — int — Primary key — NOT NULL
- email — varchar — NOT NULL — kakao email
- password — varchar — NOT NULL
user_course
- id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- course_id — VARCHAR(255)
- distance — double — NOT NULL
- duration — int — NOT NULL — minute
- pace — int — NOT NULL — sec/km
- id2 — int — Foreign key → user.id — NOT NULL
weekly_course
- weekly_course_id — VARCHAR(255) — Primary key — NOT NULL
- user_course_id — int — NOT NULL
- ranking — int — NOT NULL
- selected_date — int — NOT NULL
- id2 — int — Foreign key → review.id — NOT NULL
- user_id — int — Foreign key → review.user_id — NOT NULL
- user_course_id2 — int — Foreign key → review.user_course_id — NOT NULL
weekly_course_pic
- weekly_course_pic_id — int — 카카오 api에서 사진 불러오기
- weekly_course_pic_url — VARCHAR(255)
- weekly_course_id — VARCHAR(255) — Foreign key → weekly_course.weekly_course_id — NOT NULL