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 (위치)