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