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