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)