samcomo
Tables (6)
member
- id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- email — varchar(255)
- fcm_token — varchar(255)
- latitude — double
- longitude — double
- nickname — varchar(255)
- password — varchar(255)
- phone — varchar(255)
- profile_image_url — varchar(255)
- role — enum
- status — enum
pin
- pin_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- address — varchar(255)
- description — varchar(255)
- found_at — datetime(6)
- latitude — double
- longitude — double
- member_id — bigint
- report_id — bigint
pin_image
- pin_image_id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- image_url — varchar(255) — NOT NULL
- pin_pin_id — bigint
refresh_token
- id — bigint
- expiration — varchar(255)
- member_id — bigint
- refresh_token — varchar(255)
report
- id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- description — varchar(255)
- latitude — double
- longitude — double
- pet_name — varchar(255)
- pet_type — enum
- report_status — enum
- road_address — varchar(255)
- shows_phone — bit
- species — varchar(255)
- street_address — varchar(255)
- title — varchar(255)
- views — bigint
- member_id — bigint
report_image
- id — bigint
- created_at — datetime(6) — NOT NULL
- updated_at — datetime(6) — NOT NULL
- image_url — varchar(255) — NOT NULL
- report_id — bigint