이슈트렌드
테이블 (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