newsfeed
Tables (3)
board (게시판)
- board_id (boardId) — bigint auto increment — Primary key — NOT NULL
- user_id (userId) — varchar(200) — Foreign key → user.user_id — NOT NULL
- title — varchar(50)
- content — varchar(255)
- create_date (createDate) — datetime
- modify_date (modifyDate) — datetime
- img_url (imgUrl) — varchar(255)
relationship (친구신청)
- r_id (rId) — bigint auto increment — Primary key — NOT NULL
- to_friend_id (toFriendId) — varchar(200) — Foreign key → user.user_id — NOT NULL
- from_friend_id (fromFriendId) — varchar(200)
- status — tinyint
user (유저)
- user_id (userId) — varchar(200) — Primary key — NOT NULL
- password — varchar(255)
- user_name (userName) — varchar(50)
- age — int
- interest — varchar(50)
- create_date (createDate) — datetime
- modify_date (modifyDate) — datetime
- withdraw_yn (withdrawYn) — varchar(10)