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)