newsfeed
Tables (3)
board (게시판)
- board_id (게시판 id) — bigint auto increment — Primary key — NOT NULL
- user_id (유저 id) — varchar(200) — Foreign key → user.user_id — NOT NULL
- title (제목) — varchar(50)
- content (내용) — varchar(255)
- write_date (작성일) — datetime
- modify_date (수정일) — datetime
- img_url (사진주소) — varchar(255)
relationship (친구신청)
- r_id (Key) — bigint auto increment — Primary key — NOT NULL
- user_id (유저 id) — varchar(200) — Foreign key → user.user_id — NOT NULL
- from_friend_id (친구신청받은id) — varchar(200)
- status (상태) — int
user (유저)
- user_id (유저 id) — varchar(200) — Primary key — NOT NULL
- password (비밀번호) — varchar(255) — NOT NULL
- user_name (이름) — varchar(50)
- age (나이) — int
- interest (취미) — varchar(50)
- join_date (가입일) — datetime
- modify_date (수정일) — datetime
- status (상태) — int