test
Tables (3)
course (코스정보)
- course_id (Key) — id — Primary key — NOT NULL
- course_name (Field) — string
- course_latitude (Field2) — string
- course_longitude (Field3) — string
- course_qr (Field4) — string
user (유저)
- user_id (Key) — int — Primary key — NOT NULL
- user_login_id (Field) — string
- user_login_pw (Field2) — string
- user_name (Field3) — string
user_course (유저_코스)
- user_course_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → user.user_id — NOT NULL
- course_id (Key3) — id — Foreign key → course.course_id — NOT NULL