자율주행

테이블 (9)

Contest (경진대회)

  • contest_id (Key) — Long — 기본 키 — NOT NULL
  • date (Field) — LocalDate
  • title (Field3) — String
  • location (Field4) — String
  • awards (Field8) — text
  • created_at (Field9) — LocalDateTime
  • updated_at (Field10) — LocalDateTime
  • deleted_at (Field2) — LocalDateTime
  • is_deleted (Field5) — boolean

ContestAIVehicle (차량)

  • primaryKey (Key) — Integer — 기본 키 — NOT NULL
  • contestPk (Field) — int
  • vehicleNumber (Field2) — int

ContestApplyFile (Untitled5)

  • primaryKey (Key) — Integer — 기본 키 — NOT NULL
  • contestPk (Field) — int
  • uuid (Field2) — String
  • contestName (Field3) — String
  • teamName (Field4) — String
  • userPassword (Field5) — String
  • uploadedFilePath (Field6) — String
  • originFilePath (Field7) — String
  • description (Field8) — String
  • isAssigned (Field9) — boolean
  • registerDate (Field10) — LocalDate

ContestScenario (Untitled4)

  • primaryKey (Key) — Integer — 기본 키 — NOT NULL
  • contestPk (Field) — int
  • dayNight (Field2) — int
  • weather (Field3) — int
  • weatherAmount (Field4) — double
  • vehicle (Field5) — int
  • drivingRoute (Field6) — int

ContestTeamCrash (Untitled3)

  • primaryKey (Key) — Integer — 기본 키 — NOT NULL
  • contestPk (Field) — int
  • teamName (Field2) — String
  • crashType (Field3) — int
  • crashNumber (Field4) — int
  • lapTime (Field5) — int

ContestTeamLapTime (Untitled2)

  • primaryKey (Key) — Integer — 기본 키 — NOT NULL
  • contestPk (Field) — int
  • teamName (Field2) — String
  • wayPoint (Field3) — int
  • lapTime (Field4) — int

FAQ (Untitled)

  • faq_id (Key) — 기본 키 — NOT NULL
  • question (Field) — text
  • answer (Field2) — text
  • is_deleted (Field3) — boolean
  • updated_at (Field4) — LocalDateTime
  • created_at (Field5) — LocalDateTime
  • deleted_at (Field6) — LocalDateTime

Member (사용자)

  • member_id (Key) — Long — 기본 키 — NOT NULL
  • email (Field) — String — unique ID 대체용
  • password (Field2) — String
  • name (Field3) — String
  • mobile (Field8) — String
  • roleType (Field4) — RoleType — 심사위원, 사용자
  • oauthId (Field5) — String
  • profileImageFileKey (Field6) — String
  • profileImageUrl (Field7) — String
  • created_at (Field9) — LocalDateTime
  • deleted (Field10) — boolean
  • updated_at (Field11) — LocalDateTime
  • deleted_at (Field12) — LocalDateTime

Notice (공지)

  • notice_id (Key) — Long — 기본 키 — NOT NULL
  • title (Field2) — String
  • content (Field3) — String
  • created_at (Field4) — LocalDateTime
  • updated_at (Field) — LocalDateTime
  • deleted_at (Field6) — LocalDateTime
  • is_deleted (Field5) — boolean