MeetUP
Tables (7)
Category (Untitled4)
- id (Key) — PK, AI — Primary key — NOT NULL
- kind (모임장소종류) — UK
Comment (Untitled7)
- id (아이디) — PK, AI — Foreign key → User.id — NOT NULL
- id (Key2) — PK, AI — Foreign key → Location.id — NOT NULL
Like (Untitled6)
- id (Key) — PK, AI — Primary key — NOT NULL
- score (별점)
- user (아이디) — FK — Foreign key → User.id — NOT NULL
- id (Key2) — FK — Foreign key → Location.id — NOT NULL
Location (Untitled5)
- id (Key2) — PK, AI — Primary key — NOT NULL
- category (Key) — Foreign key → Category.id — NOT NULL
- score (Field)
- api_key (api랑 매칭 할 키)
Moim (Untitled2)
- id (Key) — PK, AI — Primary key — NOT NULL
- title (방제)
- active (활성화여부)
- master (방주인) — FK — Foreign key → User.id — NOT NULL
- created (방만든시간)
- modified (수정시간)
- maxMembers (최대인원수)
- password (방비번)
User (Untitled)
- id (아이디) — PK, AI — Primary key — NOT NULL
- email (이메일) — UK
- password (비밀번호)
- adress (주소)
- picture (프사경로)
- admin (어드민 권한)
UserToMoim (Untitled3)
- Key — Primary key — NOT NULL
- user (아이디) — FK — Foreign key → User.id — NOT NULL
- Moim (모임) — FK — Foreign key → Moim.id — NOT NULL
- gps (위치)