MTT

Tables (12)

BIG_CATEGORY (Untitled4)

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

CATEGORY (Untitled6)

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

COMMENT (Untitled10)

  • id (Key2) — Foreign key → MENTOR_BOARD.id — NOT NULL
  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • text (Field)

LIKEBOARD (Untitled11)

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

MEMBER (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field2)
  • password (Field3)
  • phone (Field4)
  • education (Field5)
  • career (Field6)
  • certification (Field7)
  • portfolio (Field8)
  • role (Field9)

MENTOR_BOARD (Untitled3)

  • id (Key2) — Primary key — NOT NULL
  • id (Key) — Foreign key → MEMBER.id — NOT NULL
  • title (Field)
  • category (Field2)
  • deadline (Field3)
  • dday (Field4)
  • status (Field5)

MIDDLE_CATEGORY (Untitled5)

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

QUESTION (Untitled12)

  • id (Key2) — Foreign key → MENTOR_BOARD.id — NOT NULL
  • id (Key3) — Foreign key → MENTOR_BOARD.id — NOT NULL
  • status (Field)

REGION (Untitled9)

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

REGION AND MEMBER (Untitled8)

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

ROLE (Untitled7)

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

ROLE AND MEMBER (Untitled)

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