HighthonErd

Tables (5)

Account

  • id (고유번호) — String — Primary key — NOT NULL
  • uid (아이디) — String
  • name (이름) — String
  • password (비밀번호) — String
  • point (점수) — Number
  • school (학교) — String

Asset

  • id (고유번호) — String — Primary key — NOT NULL
  • url (이미지링크) — String
  • post (장소) — String — Foreign key → Place.id — NOT NULL

BookMark

  • id (고유번호) — String — Primary key — NOT NULL
  • account (계정) — String — Foreign key → Account.id — NOT NULL
  • place (장소) — String — Foreign key → Place.id — NOT NULL
  • createdAt (생성일) — Timestamp

Comment

  • id (고유번호) — String — Primary key — NOT NULL
  • content (내용) — String
  • writer (작성자) — String — Foreign key → Account.id — NOT NULL
  • post (게시물) — String — Foreign key → Place.id — NOT NULL

Place

  • id (고유번호) — String — Primary key — NOT NULL
  • place (장소) — String
  • way (가는길) — String
  • content (내용) — String
  • url (이미지링크) — String[]
  • point (점수) — Number
  • latitude (위도) — String
  • longtitude (경도) — String
  • writer (작성자) — String — Foreign key → Account.id — NOT NULL
  • createdAt (생성일) — String