mating

Tables (7)

comment

  • comment_id — bigint — Primary key — NOT NULL
  • content — varchar(255)
  • like_count — int
  • liked — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • post_id — bigint — Foreign key → post.post_id — NOT NULL
  • user_id — bigint — Foreign key → member.user_id — NOT NULL

comment_like

  • comment_like_id — bigint — Primary key — NOT NULL
  • comment_id — bigint — Foreign key → comment.comment_id — NOT NULL
  • user_id — bigint — Foreign key → member.user_id — NOT NULL

member

  • user_id — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • role — enum
  • created_at — timestamp
  • updated_at — timestamp
  • user_profile_id — bigint — Foreign key → user_profile.user_profile_id — NOT NULL

post

  • post_id — bigint — Primary key — NOT NULL
  • content — text
  • like_count — int
  • view_count — int
  • liked — boolean
  • created_at — timestamp
  • updated_at — timestamp
  • title — varchar(255)
  • user_id — bigint — Foreign key → member.user_id — NOT NULL

post_like

  • post_like_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → member.user_id — NOT NULL
  • post_id — bigint — Foreign key → post.post_id — NOT NULL

upload_file

  • upload_file_id — bigint — Primary key — NOT NULL
  • file_path — varchar(255)
  • store_filename — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp
  • upload_file_name — varchar(255)

user_profile

  • user_profile_id — bigint — Primary key — NOT NULL
  • city — varchar(255)
  • zipcode — varchar(255)
  • street — varchar(255)
  • age — int
  • gender — varchar(255)
  • nick_name — varchar(255)
  • phone_number — varchar(255)
  • provider — varchar(255)
  • provider_id — varchar(255)
  • upload_file_id — bigint — Foreign key → upload_file.upload_file_id — NOT NULL