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