135

Tables (23)

chat_join

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • member_id — int8
  • chat_room_id — int8

chat_message

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • message — varchar(255) — NOT NULL
  • chat_join_id — int8 — NOT NULL

chat_room

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • name — varchar(255) — NOT NULL

member

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • birth_date — date
  • email — varchar(255)
  • gender — int2
  • name — varchar(50)
  • password — varchar(255)
  • profile_img — varchar(200)
  • refresh_token — varchar(255)
  • role — int2

mentor

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • approved — bool
  • bio — text
  • matching_status — bool
  • one_line_bio — varchar(200)
  • portfolio — text
  • member_id — int8 — NOT NULL
  • tech_stacks — _varchar

mentor_mentee_matching

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • member_id — int8
  • mentor_id — int8
  • approved — bool

mentor_review

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • content — text
  • member_id — int8
  • mentor_id — int8

mentor_tech_stack

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • mentor_id — int8
  • tech_stack_id — int8

notification

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • created_at — timestamp(6)
  • message — varchar(255)
  • read — bool — NOT NULL
  • member_id — int8

post

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • content — varchar(255)
  • file_paths — _varchar
  • is_draft — bool
  • likes — int4 — NOT NULL
  • subject — varchar(255)
  • tech_stacks — _varchar
  • thumbnail — varchar(255)
  • author_id — int8

post_comment

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • content — varchar(255)
  • likes — int4 — NOT NULL
  • author_id — int8
  • parent_comment_id — int8
  • post_id — int8

post_comment_likes

  • comment_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Primary key — NOT NULL

post_likes

  • post_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Primary key — NOT NULL

qna

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • content — varchar(255)
  • is_draft — bool
  • likes — int4 — NOT NULL
  • subject — varchar(255)
  • author_id — int8

qna_comment_likes

  • comment_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Primary key — NOT NULL

qna_likes

  • qna_id — int8 — Primary key — NOT NULL
  • member_id — int8 — Primary key — NOT NULL

qnacomment

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • content — varchar(255)
  • likes — int4 — NOT NULL
  • author_id — int8
  • parent_comment_id — int8
  • qna_id — int8

report

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • reason — varchar(255) — NOT NULL
  • status — varchar(255)
  • type — varchar(255)
  • post_id — int8
  • qna_id — int8
  • member_id — int8
  • OFFENSIVE_LANGUAGE_AND_HATE::character — varying
  • HARMFUL_OR_DANGEROUS_CONTENT::character — varying
  • REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
  • MALICIOUS_CONTENT::character — varying)::text)))
  • COMPLETED::character — varying
  • REJECTED::character — varying)::text)))

report_post

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • reason — varchar(255) — NOT NULL
  • status — varchar(255)
  • post_id — int8
  • member_id — int8
  • OFFENSIVE_LANGUAGE_AND_HATE::character — varying
  • HARMFUL_OR_DANGEROUS_CONTENT::character — varying
  • REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
  • MALICIOUS_CONTENT::character — varying)::text)))
  • COMPLETED::character — varying
  • REJECTED::character — varying)::text)))

report_post_comment

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • reason — varchar(255) — NOT NULL
  • status — varchar(255)
  • comment_id — int8
  • member_id — int8
  • OFFENSIVE_LANGUAGE_AND_HATE::character — varying
  • HARMFUL_OR_DANGEROUS_CONTENT::character — varying
  • REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
  • MALICIOUS_CONTENT::character — varying)::text)))
  • COMPLETED::character — varying
  • REJECTED::character — varying)::text)))

report_qna

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • reason — varchar(255) — NOT NULL
  • status — varchar(255)
  • qna_id — int8
  • member_id — int8
  • OFFENSIVE_LANGUAGE_AND_HATE::character — varying
  • HARMFUL_OR_DANGEROUS_CONTENT::character — varying
  • REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
  • MALICIOUS_CONTENT::character — varying)::text)))
  • COMPLETED::character — varying
  • REJECTED::character — varying)::text)))

report_qnacomment

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • reason — varchar(255) — NOT NULL
  • status — varchar(255)
  • comment_id — int8
  • member_id — int8
  • OFFENSIVE_LANGUAGE_AND_HATE::character — varying
  • HARMFUL_OR_DANGEROUS_CONTENT::character — varying
  • REPEATED_CONTENT_AND_ADVERTISEMENT::character — varying
  • MALICIOUS_CONTENT::character — varying)::text)))
  • COMPLETED::character — varying
  • REJECTED::character — varying)::text)))

tech_stack

  • id — int8 — Primary key — NOT NULL
  • created_date — timestamp(6)
  • modified_date — timestamp(6)
  • name — varchar(50)