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