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