SPRINGSECURITY

Tables (3)

NOTE (CopyOfUSER)

  • NOTEID (ID) — LONG — Primary key — NOT NULL
  • USERID (ID2) — LONG — Foreign key → USER.USERID — NOT NULL
  • title (Field) — String
  • content (Field2) — STRING

NOTICE (CopyOfUSER2)

  • NOTICEID (ID) — LONG — Primary key — NOT NULL
  • TITLE (Field) — String
  • CONTENT (Field2) — STRING
  • USERID (ID2) — LONG — Foreign key → USER.USERID — NOT NULL

USER

  • USERID (ID) — LONG — Primary key — NOT NULL
  • username (Field) — String
  • password (Field2) — STRING
  • AUTHORITY (ROLE) — STRING