new_remoa
Tables (35)
access_token
- id — bigint — Primary key — NOT NULL
- blacklisted — bit(1) — NOT NULL
- expiration_date — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- token — varchar(1000)
category
- category_id — bigint — Primary key — NOT NULL
- name — varchar(255)
category_seq
- next_val — bigint
comment
- comment_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- like_count — int
- commented_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- content — varchar(255)
comment_bookmark
- comment_bookmark_id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.comment_id
- member_id — bigint — Foreign key → member.member_id
comment_bookmark_seq
- next_val — bigint
comment_feedback
- comment_feedback_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- comment_comment_id — bigint — Foreign key → comment.comment_id
- feedback_feedback_id — bigint — Foreign key → feedback.feedback_id
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- time — datetime(6)
- type — enum('COMMENT','FEEDBACK')
comment_like
- comment_like_id — bigint — Primary key — NOT NULL
- comment_id — bigint — Foreign key → comment.comment_id
- member_id — bigint — Foreign key → member.member_id
comment_like_seq
- next_val — bigint
comment_reply
- comment_reply_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- like_count — int
- comment_id — bigint — Foreign key → comment.comment_id
- comment_replied_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- content — varchar(255)
comment_reply_like
- comment_reply_like_id — bigint — Primary key — NOT NULL
- comment_reply_id — bigint — Foreign key → comment_reply.comment_reply_id
- member_id — bigint — Foreign key → member.member_id
comment_reply_like_seq
- next_val — bigint
feedback
- feedback_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- like_count — int
- page_number — int
- feedback_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- content — varchar(255)
feedback_bookmark
- feedback_bookmark_id — bigint — Primary key — NOT NULL
- feedback_id — bigint — Foreign key → feedback.feedback_id
- member_id — bigint — Foreign key → member.member_id
feedback_bookmark_seq
- next_val — bigint
feedback_like
- feedback_like_id — bigint — Primary key — NOT NULL
- feedback_id — bigint — Foreign key → feedback.feedback_id
- member_id — bigint — Foreign key → member.member_id
feedback_like_seq
- next_val — bigint
feedback_reply
- feedback_reply_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- like_count — int
- feedback_id — bigint — Foreign key → feedback.feedback_id
- feedback_reply_time — datetime(6)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- content — varchar(255)
feedback_reply_like
- feedback_reply_like_id — bigint — Primary key — NOT NULL
- feedback_reply_id — bigint — Foreign key → feedback_reply.feedback_reply_id
- member_id — bigint — Foreign key → member.member_id
feedback_reply_like_seq
- next_val — bigint
file
- upload_file_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- post_id — bigint — Foreign key → post.post_id
- extension — varchar(255)
- original_file_name — varchar(255)
- save_file_name — varchar(255)
- store_file_url — tinytext
file_seq
- next_val — bigint
follow
- follow_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- from_member_id — bigint — Foreign key → member.member_id
- to_member_id — bigint — Foreign key → member.member_id
follow_seq
- next_val — bigint
inquiry
- inquiry_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- modified — bit(1)
- replied — bit(1)
- view — int — NOT NULL
- modified_time — datetime(6)
- posting_time — datetime(6)
- author — varchar(255)
- content — varchar(255)
- title — varchar(255)
inquiry_reply
- inquiry_reply_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- modified — bit(1)
- inquiry_id — bigint — Foreign key → inquiry.inquiry_id
- modified_time — datetime(6)
- posting_time — datetime(6)
- author — varchar(255)
- reply_content — varchar(255)
- reply_title — varchar(255)
member
- member_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- sex — bit(1)
- term_consent — bit(1)
- kakao_id — bigint
- account — varchar(255)
- birth — varchar(255)
- email — varchar(255)
- name — varchar(255)
- nickname — varchar(255)
- password — varchar(255)
- phone_number — varchar(255)
- profile_image — varchar(255)
- university — varchar(255)
- one_line_introduction — tinytext
- role — enum('ADMIN','USER')
member_category
- member_category_id — bigint — Primary key — NOT NULL
- category_id — bigint — Foreign key → category.category_id
- member_id — bigint — Foreign key → member.member_id
member_category_seq
- next_val — bigint
notice
- notice_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- modified — bit(1)
- view — int — NOT NULL
- modified_time — datetime(6)
- posting_time — datetime(6)
- author — varchar(255)
- content — varchar(255)
- title — varchar(255)
post
- post_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- like_count — int
- page_count — int
- scrap_count — int
- views — int
- category_id — bigint — Foreign key → category.category_id
- member_id — bigint — Foreign key → member.member_id
- posting_time — datetime(6)
- thumbnail_upload_file_id — bigint — Foreign key → file.upload_file_id
- contest_aware_type — varchar(255)
- contest_name — varchar(255)
- deadline — varchar(255)
- title — varchar(255)
- youtube_link — varchar(255)
post_like
- post_like_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
post_like_seq
- next_val — bigint
post_scrap
- post_scrap_id — bigint — Primary key — NOT NULL
- deleted — bit(1)
- member_id — bigint — Foreign key → member.member_id
- post_id — bigint — Foreign key → post.post_id
- scrap_time — datetime(6)
post_scrap_seq
- next_val — bigint