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