demo-auth

Tables (7)

Social-User-Google (CopyOfCopyOfUntitled2)

  • id (Key) — google12309812409 — Primary key — NOT NULL
  • name (Field) — 이예진
  • email (Field2) — [email protected]
  • phone (Field3) — 010-4649-3583

Social-User-kakao (Untitled2)

  • id (Key) — kakao12309812409 — Primary key — NOT NULL
  • name (Field) — 이예진
  • email (Field2) — [email protected]
  • phone (Field3) — 010-4649-3583

Social-User-naver (CopyOfUntitled2)

  • id (Key) — naver12309812409 — Primary key — NOT NULL
  • name (Field) — 이예진
  • email (Field2) — [email protected]
  • phone (Field3) — 010-4649-3583

User (Untitled)

  • id (Key) — PK — Primary key — NOT NULL
  • role (Field)
  • user_name (Field2)
  • email (Field3) — UK
  • password (Field4)
  • phone (Field5)
  • created_at (Field6)
  • updated_at (Field7)

User-demo

  • id (Key) — PK — Primary key — NOT NULL
  • social_id (Key2) — PK — Foreign key → User-social.social_id — NOT NULL
  • role (Field8)
  • user_email (Field) — UK
  • user_pwd (Field2)
  • name (Field3)
  • phone (Field4)
  • created_at (Field5)
  • updated_at (Field6)

User-social

  • social_id (Key) — PK — Primary key — NOT NULL
  • kakaoID (Field)
  • NaverID (Field2)
  • googleID (Field3)

User-v2 (CopyOfUntitled)

  • uuid (Key) — PK — Primary key — NOT NULL
  • user_id (Field) — nullable
  • user_pwd (Field2)
  • user_email (Field3)
  • user_name (Field4) — not null
  • user_phone (Field5) — not null
  • kakao_id (Field6) — UK
  • naver_id (Field7) — UK
  • google_id (Field8) — UK
  • created_at (Field9)
  • updated_at (Field10)