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)