이슈트렌드

테이블 (10)

Friend (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • user_no (Key2) — LONG — 외래 키 → tbl_user.user_no
  • friendId (Field) — NOT NULL

UserActivity (Untitled3)

  • id (Key) — LONG — 기본 키
  • searchKeyword (Field2) — VARCHAR(500)
  • user_no (Key2) — LONG — 외래 키 → tbl_user.user_no
  • activityTime (Field)
  • car_no (Key3) — VARCHAR(255) — 외래 키 → tbl_car.car_no

charging_station (Untitled9)

  • stationId (Key) — 기본 키 — NOT NULL
  • province (Field) — VARCHAR(255)
  • districts (Field2) — VARCHAR(255)
  • address (Field3) — VARCHAR(255)
  • stationName (Field4) — VARCHAR(255)
  • speed (Field5) — VARCHAR(255)
  • management (Field6) — VARCHAR(255)
  • chargerType (Field7) — VARCHAR(255)
  • chargingPrice (Field8) — VARCHAR(255)
  • areaIn (Field9) — VARCHAR(255)
  • available (Field10) — VARCHAR(255)
  • latitude (Field11) — VARCHAR(255)
  • longitude (Field12) — VARCHAR(255)
  • reservation_possible (Field13) — VARCHAR(255)

tbl_articles (Untitled7)

  • id (Key) — LONG — 기본 키
  • title (Field2) — VARCHAR(300) — NOT NULL
  • content (Field4) — DATETIMNE
  • published_date (Field) — VARCHAR(255)
  • source (Field3) — VARCHAR(255)
  • image_path (Field5) — VARCHAR(255)

tbl_board_post (Untitled4)

  • post_no (Key) — LONG — 기본 키
  • text (Field2) — VARCHAR(10000)
  • write_date (Field3) — DATETIMNE
  • img (Field4) — VARCHAR(2500)
  • user_no (Key2) — LONG — 외래 키 → tbl_user.user_no

tbl_bookmark (Untitled8)

  • bookmarkId (Key) — 기본 키 — NOT NULL
  • createdDate (Field)
  • user_no (Key2) — LONG — 외래 키 → tbl_user.user_no
  • car_no (Key3) — VARCHAR(255) — 외래 키 → tbl_car.car_no

tbl_car (Untitled2)

  • car_no (Key) — VARCHAR(255) — 기본 키
  • carImage (Field2) — VARCHAR(10000)
  • car_name (Field3) — DATETIMNE
  • brands (Field4) — VARCHAR(50)
  • categories (Field6) — VARCHAR(2500)
  • displacement (Field7) — VARCHAR(2500)
  • total_range (Field5) — VARCHAR(255)
  • battery_capacity (Field8) — VARCHAR(255)
  • release_price (Field9) — VARCHAR(255)
  • efficiency (Field) — VARCHAR(255)
  • co2_emission (Field10) — VARCHAR(255)
  • charging_speed (Field11) — VARCHAR(255)
  • fast_charging_speed (Field12) — VARCHAR(255)
  • slow_charging_time (Field13) — VARCHAR(255)
  • direct_co2_emission (Field14) — VARCHAR(255)
  • indirect_co2_emission (Field15) — VARCHAR(255)
  • Field16 — VARCHAR(255)

tbl_car_comments (Untitled6)

  • car_comment_no (Key2) — LONG — 기본 키
  • keyword (Field) — VARCHAR(50)
  • user_no (Key) — LONG — 외래 키 → tbl_user.user_no
  • text (Field2) — VARCHAR(255)
  • write_date (Field3) — VARCHAR(255)

tbl_post_comments (Untitled5)

  • comment_no (Key) — LONG — 기본 키
  • text (Field) — VARCHAR(255)
  • write_date (Field3) — DATETIMNE
  • user_no (Key2) — LONG — 외래 키 → tbl_user.user_no
  • post_no (Key3) — LONG — 외래 키 → tbl_board_post.post_no

tbl_user (Untitled)

  • user_no (Key) — LONG — 기본 키
  • profile_image (Field) — VARCHAR(1000)
  • email (Field2) — VARCHAR(100) — NOT NULL
  • password (Field3) — VARCHAR(100) — NOT NULL
  • access_token (Field4) — VARCHAR(255)
  • refresh_token (Field8) — VARCHAR(400)
  • refresh_token_expiry_date (Field9) — DATETIME
  • nick_name (Field10) — VARCHAR(20) — NOT NULL