newsfeed

Tables (5)

board (게시글)

  • board_id (id) — bigint auto increment — Primary key — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → user.user_id — NOT NULL
  • title (제목) — varchar(50)
  • content (내용) — varchar(255)
  • write_date (작성일) — datetime
  • modify_date (수정일) — datetime
  • img_add (사진 주소) — varchar(255)

friend (친구 신청)

  • friend_id (id) — big int auto increment — Primary key — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → user.user_id — NOT NULL
  • owner_id (친구 id) — bigint

relationship (관계)

  • relationship_id (Key) — bigint auto increment — Primary key — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → friend.user_id — NOT NULL
  • owner_id (친구id) — bigint

user (유저)

  • user_id (id) — bigint auto increment — Primary key — NOT NULL
  • emaill (email) — email — NOT NULL
  • pasword (비밀번호) — varchar(50) — NOT NULL
  • user_name (유저 이름) — varchat(30)
  • age (유저 나이) — int
  • interest (유저 취미) — varchar(60)
  • date (가입 일자) — datetime

withdraw_user (탈퇴 회원)

  • withdraw_id (id) — bigint — Primary key — NOT NULL
  • user_email (email) — email