clone_airbnb

Tables (5)

Auth (Untitled)

  • nickname (닉네임) — String — Primary key
  • useremail (유저이메일) — String
  • password (비밀번호) — String
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date

Chat (Untitled5)

  • nickname (닉네임) — String — Foreign key → Auth.nickname
  • chat (채팅) — String
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date

Comment (Untitled3)

  • commentId (코멘트아이디) — Number — Primary key
  • postId (포스트아이디) — String — Foreign key → Post.postId
  • nickname (닉네임) — String — Foreign key → Auth.nickname
  • comment (코멘트) — String
  • createdAt (생성날짜) — Date
  • updateAt (수정날짜) — Date

Post (Untitled2)

  • postId (포스트아이디) — String — Primary key
  • details (상세설명) — Object — Primary key — NOT NULL
  • title (제목) — String
  • location (장소) — String
  • length (거리) — String
  • date (숙박기간) — String
  • image (이미지) — String
  • star (별점) — String
  • price (가격) — String
  • category (카테고리) — String
  • url — String
  • score (후기) — strting
  • createdAt (생성날짜) — Date
  • updatedAt (수정날짜) — Date

Post-details (Untitled4)

  • details (상세설명) — Object — Foreign key → Post.details — NOT NULL
  • hosting (호스트) — String
  • infomation (호스트 정보) — String
  • money (가격) — String
  • descirption (설명) — String