MTT_KJH
Tables (12)
application (신청)
- id (PK) — bigint — Primary key — NOT NULL
- class_publish_id (멘토링FK) — bigint — Foreign key → class_publish.class_id — NOT NULL
- member_id (멤버FK) — bigint — Foreign key → member.id — NOT NULL
- state (상태) — char(1)
- created_date (생성일) — datetime
- last_modified_date (수정일) — datetime
category (카테고리)
- id (PK) — bigint — Primary key — NOT NULL
- category_parent_id (카테고리 부모 id) — bigint — Foreign key → category.id — NOT NULL
- category_name (카테고리 이름) — varchar(30)
- writer (작성자) — varchar()
- modifier (수정자) — varchar()
- use_yn (사용여부) — char(1)
- created_date (작성일) — datetime
- last_modified_date (수정일) — datetime
category_mentoring (카테고리멘토링맵핑)
- category_id (카테고리PK) — bigint — Foreign key → class.id — NOT NULL
- class_id (클래스PK) — bigint — Foreign key → category.id — NOT NULL
class (클래스)
- id (PK) — bigint — Primary key — NOT NULL
- member_id (멤버FK) — bigint — Foreign key → member.id — NOT NULL
- title (제목) — varchar()
- content (내용) — varchar()
- use_yn (사용여부) — char(1)
- created_date (작성일) — datetime
- last_modified_date (수정일) — datetime
class_place (클래스 지역)
- id (PK) — bigint — Primary key — NOT NULL
- class_publish_ id (클래스발표PK) — bigint — Foreign key → class_publish.id — NOT NULL
- address (주소) — varchar()
- address_detail (상세주소) — varchar()
class_publish (클래스 발표)
- id (PK) — bigint — Primary key — NOT NULL
- class_id (멘토링FK) — bigint — Foreign key → class.id — NOT NULL
- state (상태) — char(1)
- delete_yn (삭제여부) — char(1)
- class_type (수업방식) — char(1)
- created_date (생성일) — datetime
- last_modified_date (수정일) — datetime
- deadline_date (마감일) — datetime
member (멤버)
- id (PK) — bigint — Primary key — NOT NULL
- email (로그인이메일) — varchar()
- password (비밀번호) — varchar()
- password_fail_count (비밀번호실패카운트) — int
- name (이름) — varchar(50)
- gender (성별) — char(1)
- phone (휴대폰번호) — varchar()
- address (일반주소) — varchar()
- address_detail (상세주소) — varchar()
- delete_yn (삭제여부) — char(1)
- member_type (멤버타입) — char(1)
- created_date (작성일) — datetime
- last_modified_date (수정일) — datetime
member_mentoring (멤버관심멘토링)
- class_id (클래스PK) — bigint — Foreign key → class.id — NOT NULL
- member_id (멤버PK) — bigint — Foreign key → member.id — NOT NULL
message (쪽지)
- id (PK) — bigint — Primary key — NOT NULL
- member_id (멤버PK) — bigint — Foreign key → member.id — NOT NULL
- content (내용) — varchar()
- created_date (생성일) — datetime
- writer (작성자) — varchar()
qna (댓글)
- id (PK) — bigint — Primary key — NOT NULL
- class_publish_id (멘토링FK) — bigint — Foreign key → class_publish.id — NOT NULL
- member_id (멤버FK) — bigint — Foreign key → member.id — NOT NULL
- title (제목) — varchar()
- content (내용) — varchar()
- created_date (작성일) — datetime
- last_modified_date (수정일) — datetime
qna_comment (댓글코멘트)
- id (PK) — bigint — Primary key — NOT NULL
- member_id (멤버FK) — bigint — Foreign key → member.id — NOT NULL
- qna_id (qnaFK) — bigint — Foreign key → qna.id — NOT NULL
- content (내용) — varchar()
- created_date (작성일) — datetime
- last_modified_date (수정일) — datetime
review (리뷰)
- id (PK) — bigint — Primary key — NOT NULL
- member_id (멤버FK) — bigint — Foreign key → member.id — NOT NULL
- class_id (클래스FK) — bigint — Foreign key → class.id — NOT NULL
- content (내용) — varchar()
- point (평점) — int
- delete_yn (삭제여부) — char(1)
- created_date (생성일) — datetime
- last_modified_date (수정일) — datetime