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)