pawparazzi
Tables (11)
comments
- comment_id — BIGINT
- post_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
favorite_places
- favorite_place_id — BIGINT
- member_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
follows
- follow_id — BIGINT
- follower_id — BIGINT — NOT NULL
- following_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
likes
- like_id — BIGINT
- post_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
members
- member_id — BIGINT
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP
pets
- pet_id — BIGINT
- member_id — BIGINT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- type — VARCHAR(50)
- breed — VARCHAR(50)
- birth_date — DATE
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP
places
- place_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- latitude — DECIMAL(9, 6)
- longitude — DECIMAL(9, 6)
- category — VARCHAR(50)
- created_at — TIMESTAMP
posts
- post_id — BIGINT
- member_id — BIGINT — NOT NULL
- content — TEXT
- image_url — VARCHAR(255)
- video_url — VARCHAR(255)
- created_at — TIMESTAMP
storybooks
- storybook_id — BIGINT
- pet_id — BIGINT — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- story_date — DATE — NOT NULL
- created_at — TIMESTAMP
visit_records
- visit_id — BIGINT
- member_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- visit_date — DATE — NOT NULL
- visit_count — INT
- created_at — TIMESTAMP
walk_records
- walk_id — BIGINT
- pet_id — BIGINT — NOT NULL
- walk_date — DATE — NOT NULL
- duration — INT
- distance — DECIMAL(5, 2)
- location — TEXT
- created_at — TIMESTAMP