NCC

Tables (16)

Copy Of Group (CopyOf역할)

  • id (Key) — Primary key — NOT NULL
  • admin (Field)
  • doctor (Field2)
  • patient (Field3) — bool

Copy Of Organization (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • address (Field2)
  • user_attribute_id (Key3) — Foreign key → Copy Of UserAttributes.id — NOT NULL

Copy Of User (CopyOfUntitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • providers (Field2) — array — oauth providers
  • group_id (Key2) — Foreign key → Copy Of Group.id — NOT NULL

Copy Of UserAttributes (CopyOf유저 정보)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • given_name (Field2)
  • family_name (Field3)
  • email (Field5)
  • email_verified (Field4)
  • birthdate (Field6)
  • phone_nunmber_verified (Field7)
  • custom:height (Field8)
  • custom:weight (Field9)
  • sub (user_id) — Foreign key → Copy Of User.id — NOT NULL

Doctor (의사)

  • id (Key) — Primary key — NOT NULL
  • sub (유저번호) — NOT NULL
  • name (이름 전체)
  • given_name (이름)
  • family_name (성)
  • email (이메일)
  • verified (의사 확인 여부) — boolean

Doctor-Hospital (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • doctor_id (Key2) — Foreign key → Doctor.id — NOT NULL
  • hospital_id (Key3) — Foreign key → Hospital.id — NOT NULL

Doctor-Patient (Untitled2)

  • Key — Primary key — NOT NULL
  • doctor_id (Key2) — Foreign key → Doctor.id — NOT NULL
  • patient_id (Key3) — Foreign key → Patient.id — NOT NULL

EmailVerifications (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • email_validation (Field)
  • sub (user_id) — Foreign key → User.id — NOT NULL

Group (역할)

  • id (Key) — Primary key — NOT NULL
  • admin (Field) — boolean — NOT NULL
  • doctor (Field2) — boolean — NOT NULL
  • patient (Field3) — boolean — NOT NULL
  • unknown (Field4)

Hospital (병원)

  • id (Key) — Primary key — NOT NULL
  • name (Field)

Patient (환자)

  • id (Key) — Primary key — NOT NULL
  • sub (user_id) — NOT NULL
  • name (이름 전체) — string
  • given_name (이름) — string
  • family_name (성) — string
  • birthdate (Field4)
  • custom:height (Field5)
  • custom:weight (Field6)

RefreshTokens (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • refresh_token (Field)
  • Field2
  • sub (user_id) — Foreign key → User.id — NOT NULL

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • providers (Field2) — array — oauth providers

User-Group (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • group_id (Key3) — Foreign key → Group.id — NOT NULL

UserAttributes (유저 정보)

  • id (Key) — Primary key — NOT NULL
  • sub (user_id) — Foreign key → User.id — NOT NULL
  • name (Field)
  • given_name (Field2)
  • family_name (Field3)
  • email (Field5)
  • email_verified (Field4)
  • birthdate (Field6)
  • phone_nunmber_verified (Field7)
  • custom:height (Field8)
  • custom:weight (Field9)

UserCrendentials (유저 기밀정보)

  • id (Key) — Primary key — NOT NULL
  • password (Field)
  • sub (user_id) — Foreign key → User.id — NOT NULL