together
Tables (10)
ConnectIP (커넥트IP)
- Key — Primary key — NOT NULL
- ID (Key2) — int — Foreign key → User.ID — NOT NULL
- nick (Key22) — varchar(15) — Foreign key → User.nick — NOT NULL
- loc (위치정보) — int
- pairID (보호자등록ID) — int(10)
ConnectJob (취업연계)
- Key — Primary key — NOT NULL
- ID (Key2) — int — Foreign key → User.ID — NOT NULL
- nick (Key22) — varchar(15) — Foreign key → User.nick — NOT NULL
- like (관심등록) — boolean
- list (목록) — int
EmploymentBoard (취업게시판)
- epID (취업게시판 아이디) — int — Primary key — NOT NULL
- ID (Key) — int — Foreign key → User.ID — NOT NULL
- nick (닉네임이 작성자) — varchar(15) — Foreign key → User.nick — NOT NULL
- content (내용) — varchar(200)
- title (제목) — varchar(50)
FreeBoard (자유게시판)
- fbID (자유게시판 아이디) — int — Primary key — NOT NULL
- ID (Key) — int — Foreign key → User.ID — NOT NULL
- nick (닉네임이 작성자) — varchar(15) — Foreign key → User.nick — NOT NULL
- content (내용) — varchar(200)
- title (제목) — varchar(50)
GuardianBoard (보호자게시판)
- gdID (보호자게시판 아이디) — int — Primary key — NOT NULL
- ID (Key) — int — Foreign key → User.ID — NOT NULL
- nick (닉네임이 작성자) — varchar(15) — Foreign key → User.nick — NOT NULL
- content (내용) — varchar(200)
- title (제목) — varchar(50)
HealthCare (건강지킴이)
- Key3 — Primary key — NOT NULL
- ID (Key) — int — Foreign key → User.ID — NOT NULL
- nick (Key2) — varchar(15) — Foreign key → User.nick — NOT NULL
- height (키) — int
- weight (몸무게) — float
- diary (일지) — int
InfoBoard (정보게시판)
- infoID (정보게시판 아이디) — int — Primary key — NOT NULL
- ID (Key) — int — Foreign key → User.ID — NOT NULL
- nick (닉네임이 작성자) — varchar(15) — Foreign key → User.nick — NOT NULL
- content (내용) — varchar(200)
- title (제목) — varchar(50)
Profile (증명서)
- Key — Primary key — NOT NULL
- ID (Key2) — int — Foreign key → User.ID — NOT NULL
- nick (Key22) — varchar(15) — Foreign key → User.nick — NOT NULL
- image (이미지) — varchar
- birth (생년월일) — int
- info (정보) — varchar
User (사용자)
- ID (Key) — int — Primary key — NOT NULL
- nick (Key2) — varchar(15) — Primary key — NOT NULL
- userID (아이디) — varchar(15)
- pass (비밀번호) — varchar(15)
- phone (전화번호) — int(11)
- pairID (보호자등록ID) — int(10) — NOT NULL
alarm (알림목록)
- alarm_id (알림 번호) — int — Primary key — NOT NULL
- Key (Key2) — Foreign key → ConnectJob.Key — NOT NULL
- ID (Key22) — int — Foreign key → ConnectJob.ID — NOT NULL
- nick (Key222) — varchar(15) — Foreign key → ConnectJob.nick — NOT NULL