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