carming

Tables (9)

car_brand

  • brand_id — String — Primary key — NOT NULL
  • isKor — Boolean
  • logoRes — String
  • name — String

car_info

  • car_id — Long — Primary key — NOT NULL
  • carName_id — String — Foreign key → car_name.carName_id
  • brand_id — String — Foreign key → car_name.brand_id — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • resCarNo — String
  • resFirstDate — String
  • niceCarSz — String
  • resSourceType — String
  • resValidDistance — int
  • whoCar — int
  • moveCnt — int
  • makerNm — String
  • modelNm — String
  • yearType — int
  • fuel — String
  • gearBox — String
  • seatingCapacity — int
  • resColor — String
  • price — int
  • content — String
  • gradeNm — String
  • brokenYn — char
  • SoldYn — char
  • buyerId — String
  • address — String

car_name

  • carName_id — String — Primary key
  • brand_id — String — Foreign key → car_brand.brand_id — NOT NULL
  • brand — String
  • name — String

car_option

  • option_id — Long — Primary key — NOT NULL
  • car_id — Long — Foreign key → car_info.car_id — NOT NULL
  • option — String
  • carName_id — String — Foreign key → car_info.carName_id
  • brand_id — String — Foreign key → car_info.brand_id — NOT NULL

chatRooms

  • chatroom_id — String — Primary key — NOT NULL
  • car_id — Long — Foreign key → car_info.car_id — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • carName_id — String — Foreign key → car_info.carName_id
  • brand_id — String — Foreign key → car_info.brand_id — NOT NULL

messages

  • message_id — String — Primary key — NOT NULL
  • chatroom_id — String — Foreign key → chatRooms.chatroom_id — NOT NULL
  • car_id — Long — Foreign key → chatRooms.car_id — NOT NULL
  • user_id — Long — Foreign key → chatRooms.user_id — NOT NULL
  • carName_id — String — Foreign key → chatRooms.carName_id
  • brand_id — String — Foreign key → chatRooms.brand_id — NOT NULL
  • content — String
  • timestamp — date

picture

  • picture_id — Long — Primary key — NOT NULL
  • car_id — Long — Foreign key → car_info.car_id — NOT NULL
  • url — String
  • carName_id — String — Foreign key → car_info.carName_id
  • brand_id — String — Foreign key → car_info.brand_id — NOT NULL

reviews

  • review_id — String — Primary key — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • car_id — Long — Foreign key → car_info.car_id — NOT NULL
  • carName_id — String — Foreign key → car_info.carName_id
  • brand_id — String — Foreign key → car_info.brand_id — NOT NULL
  • content — String
  • rating — int

user

  • user_id — Long — Primary key — NOT NULL
  • id — String
  • password — String
  • name (username) — String
  • nickname — String