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