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