forest-rg
Tables (17)
address_code
- id (Key) — integer — Primary key — NOT NULL
- area (Field) — string
- district (Field2) — string
attached_image
- id — bigint — Primary key — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- original_file_name — varchar(255)
- url — varchar(255)
bicycle
- id — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
jwt_refresh_token
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → user.id — NOT NULL
- exp — datetime(6)
- iat — datetime(6)
notification
- id — bigint — Primary key — NOT NULL
- post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- user_id (id3) — bigint — Foreign key → user.id — NOT NULL
- contents — varchar(255)
- is_read — bit — NOT NULL
- type — integer
profile_image
- id (id3) — bigint — Foreign key → attached_image.id — NOT NULL
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
riding_condition_bicycle
- id — bigint — Primary key — NOT NULL
- post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- bicycle_id (id3) — bigint — Foreign key → bicycle.id — NOT NULL
riding_participant
- id — bigint — Primary key — NOT NULL
- post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- user_id (id3) — bigint — Foreign key → user.id — NOT NULL
- is_evaluated — bit — NOT NULL
riding_post
- id — bigint — Primary key — NOT NULL
- host_id (id2) — bigint — Foreign key → user.id — NOT NULL
- address_code (Key) — integer — Foreign key → address_code.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- level — varchar(255) — NOT NULL
- lat — double
- lng — double
- estimated_time — varchar(255) — NOT NULL
- evaluation_due_date — datetime(6) — NOT NULL
- fee — integer
- riding_date — datetime(6) — NOT NULL
- title — varchar(255) — NOT NULL
- max_participant_count — integer — NOT NULL
- min_participant_count — integer — NOT NULL
- participant_count — integer
- riding_status — varchar(255)
riding_post_comment
- id — bigint — Primary key — NOT NULL
- riding_post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- author_id (id3) — bigint — Foreign key → user.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- contents — varchar(500) — NOT NULL
- parent_comment_id — bigint
riding_routes
- list_idx — integer — Primary key — NOT NULL
- post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- route — varchar(255)
riding_sub_section
- id — bigint — Primary key — NOT NULL
- post_id (id2) — bigint — Foreign key → riding_post.id — NOT NULL
- content — varchar(500)
- title — varchar(30)
riding_thumbnail_image
- id (id3) — bigint — Foreign key → attached_image.id — NOT NULL
- post_id (id) — bigint — Foreign key → riding_post.id — NOT NULL
sub_image
- id (id2) — bigint — Foreign key → attached_image.id — NOT NULL
- sub_information_id (id3) — bigint — Foreign key → riding_sub_section.id — NOT NULL
temporary_image
- id — bigint — Primary key — NOT NULL
- original_file_name — varchar(255)
- url — varchar(255)
user
- id — bigint — Primary key — NOT NULL
- address_code (Key) — integer — Foreign key → address_code.id — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- email — varchar(255)
- introduction — varchar(255)
- is_registered — bit — NOT NULL
- banned_until — date
- no_show — smallint — NOT NULL
- point — smallint — NOT NULL
- nickname — varchar(16) — NOT NULL
- phone_number — varchar(255)
- level — varchar(255)
- riding_start_year — tinyblob
- provider — varchar(255)
- provider_id — varchar(255)
user_bicycle
- id — bigint — Primary key — NOT NULL
- user_id (id2) — bigint — Foreign key → user.id — NOT NULL
- bicycle_id (id3) — bigint — Foreign key → bicycle.id — NOT NULL