csBreaking

Tables (23)

Book (Untitled15)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • book_title (Field) — NOT NULL
  • book_description (Field2)
  • book_image_url (Field3)
  • book_store_link (Field4)

answer (Untitled8)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • vote_count (Field2) — NOT NULL
  • created_at (Field4) — NOT NULL
  • post_id (Key2) — NOT NULL — Foreign key → qna_contents.id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL

answer_comment (CopyOfUntitled8)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • vote_count (Field2) — NOT NULL
  • created_at (Field4) — NOT NULL
  • answer_id (Key2) — NOT NULL — Foreign key → answer.id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → user.user_id — NOT NULL

answer_sheet (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • text (Field)
  • question_id (Key3) — NOT NULL — Foreign key → question.id — NOT NULL

comment (8)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • date (Field4) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • id (Key3) — NOT NULL — Foreign key → job_review_contents.id — NOT NULL

job_posting_contents (Untitled17)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • title (Field2) — NOT NULL
  • tech_category (Field3) — NOT NULL
  • incruit_link (Field4) — NOT NULL
  • career (Field5) — NOT NULL
  • start_end_time (Field6) — NOT NULL
  • created_at (Field7) — NOT NULL
  • view_count (Field8) — NOT NULL
  • file (Field9)

job_review_contents (CopyOfUntitled17)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • title (Field2) — NOT NULL
  • tech_category (Field3) — NOT NULL
  • created_at (Field7) — NOT NULL
  • view_count (Field8) — NOT NULL
  • file (Field9)
  • pass_fail (Field10)
  • process_category (Field5) — NOT NULL
  • comment_count (Field6) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL

login (Untitled14)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • password (Field) — NOT NULL

message (Untitled12)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • date (Field2) — NOT NULL
  • expired_date (Field3) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL

model_answer (Untitled6)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • question_id (Key2) — NOT NULL — Foreign key → question.id — NOT NULL

notification (Untitled9)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL

notification_read (Untitled13)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • Field

oauthid (Untitled11)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • access_token (Field) — NOT NULL
  • provider (Field2) — NOT NULL

person (Untitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • email (Field2) — NULL
  • mes_allowed (Field3) — NOT NULL

problem_scrap (Untitled18)

  • scrap_id (Key3) — NOT NULL — Primary key — NOT NULL
  • user_id (Key) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • id (Key2) — NOT NULL — Foreign key → question.id — NOT NULL

qna_contents (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field2) — NOT NULL
  • vote_count (Field3) — NOT NULL
  • title (Field5) — NOT NULL
  • tech_stack (Field) — NOT NULL
  • created_at (Field6) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • comment_count (Field4) — NOT NULL
  • view_count (Field7) — NOT NULL
  • file (Field8) — 추가

question (Untitled5)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • tech_stack (Field2) — NOT NULL

role (Untitled7)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • authority (Field) — NOT NULL

score (Untitled10)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • tech_stack (Field) — NOT NULL
  • cur_score (Field2) — NULL
  • prev_score (Field3) — NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL

study_comment (CopyOf8)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • date (Field4) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL
  • id (Key3) — NOT NULL — Foreign key → study_contents.id — NOT NULL

study_contents (CopyOfUntitled172)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • text (Field) — NOT NULL
  • title (Field2) — NOT NULL
  • tech_category (Field3) — NOT NULL
  • meeting_link (Field4) — NOT NULL
  • on_offline (Field5) — NOT NULL
  • created_at (Field7) — NOT NULL
  • view_count (Field8) — NOT NULL
  • per_week (Field9) — NOT NULL
  • dayoftheweek (Field6) — NOT NULL
  • mingrade (Field10)
  • maxgrade (Field11)
  • comment_count (Field12) — NOT NULL
  • user_id (Key2) — NOT NULL — Foreign key → user.user_id — NOT NULL

user (Untitled2)

  • user_id (Key) — NOT NULL — Primary key — NOT NULL
  • nick_name (Field) — NOT NULL
  • exp (Field3) — NOT NULL
  • point (Field4) — NOT NULL
  • authority (Field5) — NOT NULL
  • checkbox (Field6) — NOT NULL
  • profile_image (Field2)
  • tech_stack (Field7)
  • tier (Field8) — NOT NULL
  • email (Field9) — NULL
  • mes_allowed (Field10) — NOT NULL
  • user_pw (Field11) — NOT NULL

user_role (Untitled3)

  • user_id (Key) — NOT NULL — Primary key — NOT NULL
  • role_id (Key2) — NOT NULL — Primary key — NOT NULL