wiyb

Tables (22)

accounts

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • social_provider — varchar(255) — NOT NULL
  • social_id — varchar(255) — NOT NULL
  • email — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

authorizations

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • session_id — varchar(255) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

balls

  • id — bigint — NOT NULL
  • piece — varchar(255)
  • spin — varchar(255)
  • launch — varchar(255)
  • feel — varchar(255)
  • dimple — varchar(255)
  • texture — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

brands

  • id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • name_ko — varchar(255)
  • image_url — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

comments

  • id — bigint — NOT NULL
  • author_id — bigint — NOT NULL
  • post_id — bigint — NOT NULL
  • reply_to — bigint
  • content — text — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

drivers

  • id — bigint — NOT NULL
  • volume — float
  • loft_degree — varchar(255)
  • is_loft_changeable — boolean
  • is_weight_changeable — boolean
  • is_weight_movable — boolean
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

equipment_evaluated_metrics

  • id — bigint — NOT NULL
  • evaluated_count — bigint — NOT NULL
  • evaluated_total — float — NOT NULL
  • rating_weight — float — NOT NULL
  • forgiveness — float
  • distance — float
  • accuracy — float
  • impact_feel — float
  • impact_sound — float
  • backspin — float
  • distance_control — float
  • stiffness — float
  • weight — float
  • trajectory — float
  • touch — float
  • grip_comfort — float
  • durability — float
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)
  • evaluated_average — float
  • forgiveness_average — float
  • distance_average — float
  • accuracy_average — float
  • impact_feel_average — float
  • impact_sound_average — float
  • backspin_average — float
  • distance_control_average — float
  • stiffness_average — float
  • weight_average — float
  • trajectory_average — float
  • touch_average — float
  • grip_comfort_average — float
  • durability_average — float
  • index — idx_evaluated_count
  • index — idx_evaluated_average
  • index — idx_forgiveness_average
  • index — idx_distance_average
  • index — idx_accuracy_average
  • index — idx_impact_feel_average
  • index — idx_impact_sound_average
  • index — idx_backspin_average
  • index — idx_distance_control_average
  • index — idx_stiffness_average
  • index — idx_weight_average
  • index — idx_trajectory_average
  • index — idx_touch_average
  • index — idx_grip_comfort_average
  • index — idx_durability_average

equipment_reviews

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • equipment_id — bigint — NOT NULL
  • evaluation_metric — varchar(255) — NOT NULL
  • like_count — int — NOT NULL
  • content — text
  • image_urls — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

equipments

  • id — bigint — NOT NULL
  • brand_id — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • view_count — bigint — NOT NULL
  • released_year — varchar(255)
  • image_urls — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

grips

  • id — bigint — NOT NULL
  • weight — varchar(255)
  • size — varchar(255)
  • core_size — varchar(255)
  • feel — varchar(255)
  • material — varchar(255)
  • torque — varchar(255)
  • diameter — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

hybrids

  • id — bigint — NOT NULL
  • numbers — varchar(255)
  • loft_degree — varchar(255)
  • lie_angle — varchar(255)
  • is_loft_changeable — boolean
  • is_weight_changeable — boolean
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

irons

  • id — bigint — NOT NULL
  • produce_type — varchar(255)
  • design_type — varchar(255)
  • numbers — varchar(255)
  • loft_degree — varchar(255)
  • lie_angle — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

posts

  • id — bigint — NOT NULL
  • author_id — bigint — NOT NULL
  • category — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • view_count — bigint — NOT NULL
  • comment_count — bigint — NOT NULL
  • image_urls — text
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

putters

  • id — bigint — NOT NULL
  • loft_degree — varchar(255)
  • weight — varchar(255)
  • neck_shape — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

shafts

  • id — bigint — NOT NULL
  • weight — varchar(255)
  • strength — varchar(255)
  • kick_point — varchar(255)
  • torque — varchar(255)
  • texture — varchar(255)
  • tip_diameter — varchar(255)
  • butt_diameter — varchar(255)
  • spin — varchar(255)
  • launch — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

user_equipment_bookmarks

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • equipment_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

user_equipment_review_likes

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • equipment_review_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

user_equipments

  • id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • equipment_id — bigint — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

user_profiles

  • id — bigint — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • gender — varchar(255) — NOT NULL
  • birth — date — NOT NULL
  • handy — int
  • height — int
  • weight — int
  • image_url — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

users

  • id — bigint — NOT NULL
  • role — varchar(255) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

wedges

  • id — bigint — NOT NULL
  • produce_type — varchar(255)
  • model — varchar(255)
  • loft_degree — varchar(255)
  • bounce — varchar(255)
  • grind — varchar(255)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)

woods

  • id — bigint — NOT NULL
  • numbers — varchar(255)
  • loft_degree — varchar(255)
  • lie_angle — varchar(255)
  • is_loft_changeable — boolean
  • is_weight_changeable — boolean
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • deleted_at — datetime(6)