MTT 2

Tables (20)

APPLICATION (Untitled13)

  • in (Key) — Primary key — NOT NULL
  • applicant_date (Field)
  • id (Key2) — Foreign key → MEMBER.id — NOT NULL
  • id (Key3) — Foreign key → MAIN_SUB_BOARD.id — NOT NULL

ATTACH_FILE (Untitled16)

  • id (Key) — Primary key — NOT NULL
  • path (Field)
  • size (Field2)
  • id (Key2) — Foreign key → MAIN_BOARD.id — NOT NULL

ATTACH_SUB_FILE (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • path (Field)
  • size (Field2)
  • id (Key2) — Foreign key → MAIN_SUB_BOARD.id — NOT NULL

CATEGORY (Untitled6)

  • id (Key3) — Primary key — NOT NULL
  • Field (categoryName)
  • id (Key32) — Foreign key → CATEGORY.id — NOT NULL

CATEGORY_MEMBER (Untitled15)

  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • id (Key3) — Foreign key → CATEGORY.id — NOT NULL

CATEGORY_POST (Untitled18)

  • id (Key3) — Foreign key → CATEGORY.id — NOT NULL
  • id (Key2) — Foreign key → MAIN_BOARD.id — NOT NULL

FREE_POST (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field3)
  • id (Key2) — Foreign key → MEMBER.id — NOT NULL

FREE_POST_REPLY (CopyOfUntitled5)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field3)
  • id (Key2) — Foreign key → FREE_POST.id — NOT NULL
  • id (Key3) — Foreign key → MEMBER.id — NOT NULL

INTEREST (Untitled19)

  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • id (Key2) — Foreign key → MAIN_SUB_BOARD.id — NOT NULL

MAIN_BOARD (Untitled3)

  • id (Key2) — Primary key — NOT NULL
  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • title (Field)
  • category (Field2)
  • education (학력)
  • career (경력)
  • certification (자격)
  • portfolio (포트폴리오)

MAIN_SUB_BOARD (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → MAIN_BOARD.id — NOT NULL
  • recruit_date (모집 시작 날짜)
  • finish_date (모집마감날짜)
  • mentoring_date (멘토링 날짜)
  • status (게시물 상태)

MEMBER (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • password (Field3)
  • phone (Field4)
  • role (Field9)
  • region (Field5)
  • role (Field6)

MENTOR_LIKE (Untitled11)

  • id (Key2) — Foreign key → MAIN_BOARD.id — NOT NULL
  • id (Key) — Foreign key → MEMBER.id — NOT NULL

MESSAGE (Untitled14)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • id (Key2) — Foreign key → MEMBER.id — NOT NULL

QUESTION (Untitled12)

  • id (question) — Primary key — NOT NULL
  • title (제목)
  • content (내용)
  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • id (Key2) — Foreign key → MAIN_SUB_BOARD.id — NOT NULL

REGION (Untitled9)

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

REGION_BOARD (Untitled8)

  • id (Key) — Foreign key → REGION.id — NOT NULL
  • id (Key3) — Foreign key → MAIN_SUB_BOARD.id — NOT NULL

REVIEW (Untitled17)

  • id (Key) — Primary key — NOT NULL
  • content (Field)
  • star_right (평점)
  • id (Key2) — Foreign key → MAIN_BOARD.id — NOT NULL
  • id (Key3) — Foreign key → MEMBER.id — NOT NULL

ROLE (Untitled7)

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

ROLE _MEMBER (Untitled)

  • id (Key) — Foreign key → ROLE.id — NOT NULL
  • id (Key2) — Foreign key → MEMBER.id — NOT NULL