4gather
Tables (9)
bookmarks
- bookmark_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- pet_fair_id — BIGINT — Foreign key → pet_fair.pet_fair_id — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
comments
- comment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at (comment_created_at) — TIMESTAMP
- updated_at (comment_updated_at) — TIMESTAMP
- status — VARCHAR(255)
- pet_fair_id — BIGINT — Foreign key → pet_fair.pet_fair_id — NOT NULL
likes
- like_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- target_id — BIGINT — NOT NULL
- target_type — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
oauth
- oauth_id — BIGINT — Primary key — NOT NULL
- oauth_provider_id — VARCHAR(255) — NOT NULL
- oauth_provider — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
pet_fair
- pet_fair_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- poster_image_url — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- simple_address — VARCHAR(255)
- detail_address — VARCHAR(255)
- pet_fair_url — TEXT
- map_url — TEXT
- content — TEXT
- counter — BIGINT
- latitude — VARCHAR(255)
- longitude — VARCHAR(255)
- tel_number — VARCHAR(255)
- status — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
pet_fair_image
- pet_fair_image_id — BIGINT — Primary key — NOT NULL
- pet_fair_id — BIGINT — Foreign key → pet_fair.pet_fair_id — NOT NULL
- image_url — TEXT — NOT NULL
- sort_order — INT
- created_at — TIMESTAMP
pet_fair_read
- pet_fair_read_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- poster_image_url — TEXT
- petFairUrl — TEXT
- map_url — TEXT
- counter — BIGINT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- simple_address — VARCHAR(255)
- detail_address — VARCHAR(255)
- latitude — VARCHAR(255)
- longitude — VARCHAR(255)
- tel_number — VARCHAR(255)
- status — VARCHAR(255)
- images — JSONB
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT
- pet_fair_id — BIGINT
replies
- reply_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- status — VARCHAR(255)
- comment_id — BIGINT — Foreign key → comments.comment_id — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at (user_created_at) — TIMESTAMP
- updated_at (user_updated_at) — TIMESTAMP
- status — VARCHAR(255)
- user_img — VARCHAR(255)
- nick_name — VARCHAR(255)
- role — VARCHAR(255)