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 (자격증)