US DIARY
Tables (14)
Checklist (체크리스트)
- ID (checklist_id) — binary(16) — Primary key — NOT NULL
- ID (city_id) — binary(16) — Foreign key → City.ID — NOT NULL
- 내용 (checklist_content) — varchar(255)
- 완료여부 (checklist_done) — int
- 삭제여부 (delete_yn) — int
- 시작날짜 (checklist_start) — date
- 완료날짜 (checklist_deadline) — date
City (도시)
- ID (city_id) — binary(16) — Primary key — NOT NULL
- 제목 (city_title) — varchar(255)
- 내용 (city_content) — longtext
- 삭제여부 (delete_yn) — int
- 공개여부 (public_yn) — int — 0: 전체공개, 1: 친구공개, 2: 나만보기
Comment (댓글)
- ID (comment_id) — binary(16) — Primary key — NOT NULL
- ID (sea_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (community_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id2) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User.ID — NOT NULL
- 내용 (comment_content) — longtext
- 삭제여부 (delete_yn) — int
- Field3
Forest (숲)
- ID (forest_id) — binary(16) — Primary key — NOT NULL
- 제목 (forest_title) — varchar(255)
- 내용 (forest_content) — longtext
- 삭제여부 (delete_yn) — int
- 공개여부 (public_yn) — int — 0: 전체공개, 1: 친구공개, 2: 나만보기
- 오늘의 질문 (forest_question) — varchar(255)
- 오늘의 답변 (forest_answer) — varchar(255)
Friends (친구)
- ID (friends_id) — binary(16) — Primary key — NOT NULL
- ID (community_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- 이름 (friends_name) — varchar(15)
- 관계 (friends_relationship) — int — 0: X, 1: 팔로우, 2: 팔로워, 3: 맞팔
- 삭제여부 (delete_yn) — int
Image_File (이미지 파일)
- ID (sea_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (community_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (imagefile_id) — binary(16)
- 원본파일명 (original_file) — varchar(255)
- 새파일명 (new_file) — varchar(255)
Inquiry (문의사항)
- ID (inquiry_id) — binary(16) — Primary key — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User.ID — NOT NULL
- 분류 (inquiry_class) — int
- 등록일 (inquiry_date) — date
- 제목 (inquiry_title) — varchar(255)
- 내용 (inquiry_content) — longtext
Like (좋아요)
- ID (like_id) — binary(16) — Primary key — NOT NULL
- ID (sea_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (community_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
Profile_Image (프로필 이미지)
- ID (profileImg_id) — binary(16) — Primary key — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User.ID — NOT NULL
- 원본파일명 (original_file) — varchar(255)
- 새파일명 (new_file) — varchar(255)
Report_Post (글 신고)
- ID (report_id) — binary(16) — Primary key — NOT NULL
- ID (sea_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (community_id) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (user_id2) — binary(16) — Foreign key → Sea.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User.ID — NOT NULL
- 작성자ID (report_writer) — varchar(255)
- 신고자ID (report_user) — varchar(255)
- 신고날짜 (report_date) — date
Sea (바다)
- ID (sea_id) — binary(16) — Primary key — NOT NULL
- ID (community_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User_Community.ID — NOT NULL
- 제목 (sea_title) — varchar(255)
- 내용 (sea_content) — longtext
- 삭제여부 (delete_yn) — int
- 공개여부 (public_yn) — int — 0: 전체공개, 1: 친구공개, 2: 나만보기
- 일기 불러오기 (diary_code) — varchar(10)
User (사용자)
- ID (user_id) — binary(16) — Primary key — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User_Place.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User_Place.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User_Place.ID — NOT NULL
- 이름 (user_name) — varchar(15)
- 비밀번호 (user_password) — varchar(255)
- 이메일 (user_email) — varchar(100)
- 성별 (user_gender) — varchar(10)
- 생년월일 (user_birth) — date
- 전화번호 (user_number) — varchar(50)
- 소속공간 (user_place) — int — 0: 숲, 1: 도시, 2: 미선택
- 탈퇴여부 (withdrawal_yn) — int
User_Community (커뮤니티)
- ID (community_id) — binary(16) — Primary key — NOT NULL
- ID (user_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (place_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → User.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → User.ID — NOT NULL
- 공간 코드 (place_code) — int — 2:바다, 3:친구
- 공간명 (place_name) — varchar(255)
- 삭제 여부 (delete_yn) — int
User_Place (사용자 공간)
- ID (place_id) — binary(16) — Primary key — NOT NULL
- ID (forest_id) — binary(16) — Foreign key → Forest.ID — NOT NULL
- ID (city_id) — binary(16) — Foreign key → City.ID — NOT NULL
- 공간 코드 (place_code) — int — 0:숲, 1: 도시
- 공간명 (place_name) — varchar(255)
- 삭제 여부 (delete_yn) — int