hotdog

Tables (8)

Chat (채팅기록)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • rooid (룸아이디) — STRING(255)
  • senderid (보낸사람아이디) — STRING(255)
  • content (채팅내용) — TEXT

QNAboards (게시판:질문)

  • userid (유저아이디) — STRING(20) — Foreign key → Users.id — NOT NULL
  • title (글제목) — STRING(255)
  • contents (내용) — TEXT

QNAcomments (게시판:질문내용)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • userid (유저아이디) — STRING(20) — Foreign key → QNAboards.userid — NOT NULL
  • content (내용) — STRING(255)
  • boradtype (게시판주제타입) — STRING(255)
  • qnaid (큐앤에이아이디) — INTEGER

Room (방정보)

  • roomid (룸아이디) — STRING(255) — Primary key — NOT NULL

Sns (게시판:sns)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • userid (유저아이디) — STRING(20) — Foreign key → Users.id — NOT NULL
  • title (제목) — STRING(255)
  • content (내용) — STRING(255)
  • dynamic-file (정적파일정보) — STRING(255)
  • writer (작성자) — STRING(255)

SnsComments (게시판:sns내용)

  • userid (유저아이디) — STRING(20) — Foreign key → Sns.userid — NOT NULL
  • content (내용) — TEXT
  • writer (작성자) — STRING(255)

UserRoom (회원 방정보)

  • userid (유저아이디) — STRING(20) — Foreign key → Users.id — NOT NULL
  • roomid (룸아이디) — STRING(255) — Foreign key → Room.roomid — NOT NULL

Users (회원)

  • id (아이디) — INTEGER — Primary key — NOT NULL
  • userid (유저아이디) — STRING(20)
  • pw (비밀번호) — STRING(255)
  • name (닉네임) — STRING(20)
  • birth (생년월일) — STRING(255)
  • address (주소) — STRING(20)
  • dogname (강아지 이름) — STRING(255)
  • RFIDcode (내장칩코드) — STRING(255)