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)