eun yeong

Tables (3)

eunyeong (users)

  • user_id (Key) — varchar2(11) — Primary key — NOT NULL
  • user_name (Field) — varchar2(15)
  • user_password (Field2) — varchar2(255)
  • email (Field3) — varchar2(50)
  • PHONE (Field4) — varchar2(13)
  • role_type (Field5) — varchar2(10)
  • status (Field6) — varchar2(10)
  • fail_count (Field7) — number
  • lock_until (Field8) — varchar2
  • Field9 — varchar2

eunyeong (seniors)

  • senior_id (Key) — varchar2 — Primary key — NOT NULL
  • seniors_name (Field)
  • seniors_birth_date (Field2)
  • floor_number (Field3)
  • user_id (Key2) — varchar2(11) — Foreign key → eunyeong.user_id — NOT NULL

eunyeong (senior_relations)

  • user_id (Key) — varchar2(11) — Foreign key → eunyeong.user_id — NOT NULL
  • RELATIONSHIP (Field) — varchar2(50)