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")