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