cu2

Tables (29)

Copy Of follow (CopyOffollow)

  • follow_id (id) — uuid — Primary key — NOT NULL
  • from_user_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

Untitled

  • coach_category_id — uuid — Foreign key → coach_category.coach_category_id — NOT NULL
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

Untitled2

  • code_category_id (Key) — uuid — Foreign key → code_category.code_category_id — NOT NULL
  • User_id (id) — uuid — Foreign key → user.User_id — NOT NULL

blog

  • Blog_id (id) — uuid — Primary key — NOT NULL
  • title — varchar(200)
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

blog_comment (CopyOfblog)

  • Blog_Comment_id (id) — uuid — Primary key — NOT NULL
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • Blog_id (id3) — uuid — Foreign key → blog.Blog_id — NOT NULL

blog_image

  • blog_image_id (id) — uuid — Primary key — NOT NULL
  • url — url
  • Blog_id (id2) — uuid — Foreign key → blog.Blog_id — NOT NULL
  • 순서 (order)

blog_like

  • blog_like_id (id) — uuid — Primary key — NOT NULL
  • Blog_Comment_id (id2) — uuid — Foreign key → blog_comment.Blog_Comment_id — NOT NULL
  • User_id (id3) — uuid — Foreign key → user.User_id — NOT NULL

blog_tag

  • blog_tag_id (id) — uuid — Primary key — NOT NULL
  • name — varchar(20)

coach_category

  • coach_category_id — uuid — Primary key — NOT NULL
  • name — varchar(20)
  • image — url

coach_profile

  • id — uuid — Foreign key → user.User_id — NOT NULL
  • org (organization_name) — varchar(20)
  • org (organization_type) — enum
  • org (organization_email) — varchar(40)
  • dept (department) — varchar(40)
  • job — varchar(40)
  • isHiring (is_hiring) — boolean
  • title — varchar(200)
  • contents — text
  • image — url
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime

coach_profile_tag (Untitled3)

  • Key — Primary key — NOT NULL
  • User_id (id) — uuid — Foreign key → coach_profile.id — NOT NULL
  • id (id2) — uuid — Foreign key → coach_tag.id — NOT NULL

coach_tag

  • id — uuid — Primary key — NOT NULL
  • name — string

coachingus_answer

  • coachingus_answer_id (id) — uuid — Primary key — NOT NULL
  • title — varchar(200)
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • coachingus_question_id (id2) — uuid — Foreign key → coachingus_question.coachingus_question_id — NOT NULL

coachingus_answer_reaction

  • reaction_id (id) — uuid — Primary key — NOT NULL
  • status — enum
  • comment — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • coachingus_answer_id (id3) — uuid — Foreign key → coachingus_answer.coachingus_answer_id — NOT NULL

coachingus_question

  • coachingus_question_id (id) — uuid — Primary key — NOT NULL
  • title — varchar(200)
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • type — enum
  • toCoach (Field)

coachingus_question_tag

  • coachingus_question_tag_id (id) — uuid — Primary key — NOT NULL
  • name — varchar(20)

code_category

  • code_category_id (Key) — uuid — Primary key — NOT NULL
  • name — varchar(20)
  • image — url

codingus_answer (CopyOfcodingus_question)

  • codingus_answer_id (id) — uuid — Primary key — NOT NULL
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • codingus_question_id (id3) — uuid — Foreign key → codingus_question.codingus_question_id — NOT NULL

codingus_answer_like

  • codingus_answer_like_id (id) — uuid — Primary key — NOT NULL
  • codingus_answer_id (id2) — uuid — Foreign key → codingus_answer.codingus_answer_id — NOT NULL
  • User_id (id3) — uuid — Foreign key → user.User_id — NOT NULL

codingus_question

  • codingus_question_id (id) — uuid — Primary key — NOT NULL
  • title — varchar(200)
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

codingus_question_tag (CopyOfblog_tag)

  • codingus_question_tag_id (id) — uuid — Primary key — NOT NULL
  • name — varchar(20)

column

  • Column_id (id) — uuid — Primary key — NOT NULL
  • title — varchar(200)
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

column_comment (CopyOfcolumn)

  • Column_comment_id (id) — uuid — Primary key — NOT NULL
  • contents — text
  • createdAt — Datetime
  • updatedAt — Datetime
  • deletedAt — Datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • Column_id (id3) — uuid — Foreign key → column.Column_id — NOT NULL

column_image

  • column_tag_id (id) — uuid — Primary key — NOT NULL
  • url — url
  • Column_id (id2) — uuid — Foreign key → column.Column_id — NOT NULL

column_like

  • column_like_id (id) — uuid — Primary key — NOT NULL
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL
  • Column_id (id3) — uuid — Foreign key → column.Column_id — NOT NULL

column_tag

  • column_tag_id (id) — uuid — Primary key — NOT NULL
  • name — varchar(20)

follow

  • follow_id (id) — uuid — Primary key — NOT NULL
  • from_user_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

point_transaction

  • point_trsc_id (id) — uuid — Primary key — NOT NULL
  • impUid — uuid
  • amount — int
  • status — enum
  • createdAt — datetime
  • User_id (id2) — uuid — Foreign key → user.User_id — NOT NULL

user

  • User_id (id) — uuid — Primary key — NOT NULL
  • name — varchar(10)
  • Email (email) — varchar(10)
  • Phone (phone_number) — varchar(20)
  • password — varchar
  • usertype (status) — enum
  • interest (code_interest) — varchar(20)
  • interest (coach_interest) — varchar(20)
  • point — int
  • score — int
  • createdAt — Datetime
  • deletedAt — Datetime
  • updatedAt — Datetime