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