rideon

Tables (19)

ChatMessage

  • message_id — BIGINT — Primary key
  • sender_id — BIGINT — Foreign key → users.id — NOT NULL
  • group_id — BIGINT — Foreign key → RidingGroup.group_id
  • message_text — TEXT
  • image_url — VARCHAR(500)
  • sent_at — TIMESTAMP

GroupMember

  • group_id — BIGINT — Foreign key → RidingGroup.group_id
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • joined_at — TIMESTAMP

RidingGroup (RideingGroup)

  • group_id — BIGINT — Primary key
  • group_name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(6)
  • image_url — VARCHAR(500)
  • latitude — DECIMAL(9,6)
  • longitude — DECIMAL(9,6)
  • limit_members — INT
  • desucription (description) — TEXT
  • deadline — DATE
  • created_at — TIMESTAMP
  • update_up (update_at) — TIMESTAMP

bike_rental_station

  • id — BIGINT — Primary key — NOT NULL
  • rental_station_name — VARCHAR(255) — NOT NULL
  • rental_station_type — VARCHAR(100)
  • address_street — TEXT
  • address_jibun — TEXT
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • operation_start_time — TIME
  • operation_end_time — TIME
  • closed_days — TEXT
  • fee_type — VARCHAR(50)
  • rental_fee — TEXT
  • bicycle_count — INTEGER
  • parking_spots — INTEGER
  • air_pump_available — BOOLEAN
  • air_pump_type — VARCHAR(100)
  • repair_station_available — BOOLEAN
  • management_phone — VARCHAR(50)
  • management_name — VARCHAR(255)
  • data_date — DATE
  • provider_code — VARCHAR(50)
  • provider_name — VARCHAR(255)
  • province — VARCHAR(100) — NOT NULL

category

  • id — BIGINT — Primary key
  • name — VARCHAR(10) — NOT NULL

inquiry

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT
  • title — TEXT
  • create_at — DATETIME

obstacle_report

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • location — GEOGRAPHY(POINT, 4326) — NOT NULL
  • report_type — ENUM('OBSTACLE', 'ROAD_DAMAGE', 'CONSTRUCTION', 'SLIPPERY', 'ETC')
  • description — TEXT
  • status — ENUM('UNCONFIRMED', 'CONFIRMED', 'RESOLVED')
  • created_at — TIMESTAMP
  • image — VARCHAR(500)

post

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • image — VARCHAR(500)
  • view_count — INTEGER
  • like_count — INTEGER
  • created_at — TIMESTAMP
  • update_at — TIMESTAMP

post_category

  • post_id — BIGINT — Foreign key → post.id
  • category_id — BIGINT — Foreign key → category.id

post_comment

  • id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → post.id
  • content — TEXT
  • created_at — TIMESTAMP

post_like

  • id — BIGINT — Primary key
  • post_id — BIGINT — Foreign key → post.id
  • created_at — TIMESTAMP

question

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('SOLVED', 'UNSOLVED')
  • view_count — INT
  • like_count — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

question_comment

  • id — BIGINT — Primary key
  • question_id — UUID — Foreign key → question.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

question_like

  • id — BIGINT — Primary key
  • question_id — UUID — Foreign key → question.id
  • created_at — TIMESTAMP

question_tag

  • question_idid (question_id) — BIGINT — Foreign key → question.id
  • tag_id — BIGINT — Foreign key → tag.id

ride_point

  • id — BIGINT — Primary key
  • ride_session_id — BIGINT — Foreign key → ride_session.id
  • location — GEOMETRY(Point, 4326) — NOT NULL
  • speed_kmh — FLOAT
  • recorded_at — TIMESTAMP

ride_session

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP — NOT NULL
  • total_distance_km — FLOAT
  • avg_speed_kmh — FLOAT
  • calories_burned — FLOAT
  • created_at — TIMESTAMP

tag

  • id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50)
  • gender — VARCHAR(10)
  • birth_date — DATE
  • age — INT
  • profile_image — VARCHAR(500)
  • created_at — TIMESTAMP
  • height — FLOAT
  • weight — FLOAT
  • provider — ENUM("original", "kakao","naver","google")