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