MTT_Table

Tables (13)

application (신청)

  • Key2 — Primary key — NOT NULL
  • bno (글번호) — Foreign key → mento_sub_post.bno — NOT NULL
  • user_code (Key) — Foreign key → mento_sub_post.user_code — NOT NULL
  • applicant_name (신청자명)
  • requested_term (요청사항)

category (카테고리)

  • Key — Primary key — NOT NULL
  • user_code (Key2) — Foreign key → mento_sub_post.user_code — NOT NULL
  • Field3
  • Key (Key3) — Foreign key → category.Key — NOT NULL
  • user_code (Key22) — Foreign key → category.user_code — NOT NULL

free_post (자유게시글)

  • bno (글번호) — Primary key — NOT NULL
  • user_code (Key) — Foreign key → user.user_code — NOT NULL
  • title (제목)
  • writer (작성자)
  • content (내용)

free_reply (자유게시글댓글)

  • rno (댓글번호) — Primary key — NOT NULL
  • bno (글번호) — Foreign key → free_post.bno — NOT NULL
  • user_code (Key) — Foreign key → free_post.user_code — NOT NULL
  • writer (작성자)
  • content (내용)

like (관심표현)

  • Key2 — Primary key — NOT NULL
  • bno (글번호) — Foreign key → mento_sub_post.bno — NOT NULL
  • user_code (Key) — Foreign key → mento_sub_post.user_code — NOT NULL

mento_post (멘토게시글)

  • bno (글번호) — Primary key — NOT NULL
  • user_code (Key) — Foreign key → user.user_code — NOT NULL
  • title (제목)
  • writer (작성자)
  • content (내용)
  • education (학력)
  • career (경력)
  • certificate (자격증)

mento_sub_post (노출되는 게시글)

  • bno (글번호) — Primary key — NOT NULL
  • user_code (Key) — Foreign key → mento_post.user_code — NOT NULL
  • title (제목)
  • writer (작성자)
  • content (내용)
  • registration_date (등록일)
  • dedline (마감일)
  • education (학력)
  • career (경력)
  • certificate (자격증)
  • mento_post_id (Field)

note (쪽지)

  • Key — Primary key — NOT NULL
  • bno (글번호) — Foreign key → mento_sub_post.bno — NOT NULL
  • user_code (Key2) — Foreign key → mento_sub_post.user_code — NOT NULL
  • writer (작성자)
  • content (내용)

qna (질문)

  • Key2 — Primary key — NOT NULL
  • user_code (Key) — Foreign key → mento_sub_post.user_code — NOT NULL
  • writer (작성자)
  • content (내용)

qna_reply (답변)

  • Key3 — Primary key — NOT NULL
  • user_code (Key) — Foreign key → qna.user_code — NOT NULL
  • writer (작성자)
  • content (내용)

region (지역)

  • Key2 — Primary key — NOT NULL
  • user_code (Key) — Foreign key → mento_sub_post.user_code — NOT NULL
  • Field
  • Field2

review (리뷰)

  • Key2 — Primary key — NOT NULL
  • bno (글번호) — Foreign key → application.bno — NOT NULL
  • user_code (Key) — Foreign key → application.user_code — NOT NULL
  • Key2 (Key22) — Foreign key → application.Key2 — NOT NULL
  • writer (작성자)
  • content (내용)
  • star_rating (별점)

user (회원)

  • user_code (Key) — Primary key — NOT NULL
  • id (아이디)
  • password (비밀번호)
  • name (이름)
  • email (이메일)
  • phone_number (전화번호)
  • address (주소)
  • education (학력)
  • career (경력)
  • certificate (자격증)