third
Tables (4)
Untitled (Users)
- Key (User_ID) — VARCHAR2(100) — Primary key — NOT NULL
- Field (Username) — VARCHAR2(40)
- Field (Email) — VARCHAR2(100)
- Field (Password) — VARCHAR2(100)
- Field (Create_Day) — Date
- Field (Updated_Day) — Date
- Field (Active) — Boolean
Untitled (UserProfile)
- Key (Profile_ID) — VARCHAR2(100) — Primary key — NOT NULL
- Key (User_ID) — VARCHAR2(100) — Foreign key → Untitled.Key — NOT NULL
- Field (First_name) — VARCHAR2(100)
- Field (Last_name) — VARCHAR2(100)
- Field (Birth) — DATE
- Field (Phone_number) — VARCHAR2(100)
- Field (Address) — VARCHAR2(100)
- Field (NIckname) — VARCHAR2(100)
- Field (Pic) — VARCHAR2(100)
Untitled (LoginHistory)
- Key (Login_ID) — VARCHAR2(100) — Primary key — NOT NULL
- Key (User_ID) — VARCHAR2(100) — Foreign key → Untitled.Key — NOT NULL
- Field (Login_time) — DATE
- Field (Logout_time) — DATE
- Field (IP_Address) — VARCHAR2(100)
Untitled (Roles)
- Key (Role_ID) — VARCHAR2(100) — Primary key — NOT NULL
- Key (User_ID) — VARCHAR2(100) — Foreign key → Untitled.Key — NOT NULL
- Field (Role_name) — VARCHAR2(100)