test

Tables (4)

Untitled3

    course (코스 정보)

    • course_id (Key) — intger — Primary key — NOT NULL
    • course_name (Field) — string
    • course_latitude (Field2) — string
    • course_longitude (Field3) — string
    • course_qr (Field4) — string

    user (유저)

    • user_id (Key) — intger — Primary key — NOT NULL
    • user_login_id (Field) — string
    • user_login_pw (Field2) — string
    • user_name (Field3) — string

    user_course (유저_코스_중간테이블)

    • user_course_id (Key) — intger — Primary key — NOT NULL
    • user_id (Key2) — intger — Foreign key → user.user_id — NOT NULL
    • course_id (Key3) — intger — Foreign key → course.course_id — NOT NULL