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)