duk

Tables (3)

Object (장애물 테이블)

  • objectIdx (Key) — bigint() — Primary key — NOT NULL
  • pointX (Field) — double
  • pointY (Field2) — double
  • routeIdx (Key2) — bigint — Foreign key → Route.routeIdx — NOT NULL

Route (경로 테이블)

  • routeIdx (Key) — bigint — Primary key — NOT NULL
  • routeName (Field2) — varchar(150)
  • mark (Field3) — int(1)
  • endX (Field4) — double
  • endY (Field5) — double
  • passPoint (Field6) — varchar(1000)
  • userIdx (Key2) — bigint — Foreign key → User.userIdx — NOT NULL

User (유저 테이블)

  • userIdx (Key) — bigint — Primary key — NOT NULL
  • status (Field) — int(1)
  • nickname (Field2) — varchar(50)
  • email (Field3) — varchar(150)
  • pw (Field4) — text