space

Tables (6)

SERVEY (Untitled4)

  • SERVEY_CODE — number — Primary key — NOT NULL
  • SERVEY_NAME — varchar2(512)
  • SERVEY_COUNT — number

SERVEY_USER (Untitled5)

  • GENDER (Key) — char(1) — Primary key — NOT NULL
  • AGE — number — Primary key — NOT NULL
  • SERVEY_CODE — number — Foreign key → SERVEY.SERVEY_CODE — NOT NULL
  • COUNT — number

SONG (Untitled6)

  • SONGNAME — varchar2(512) — Primary key — NOT NULL
  • SERVEY_CODE — number — Foreign key → SERVEY.SERVEY_CODE — NOT NULL
  • SONGCOUNT — number

SPACEBOARD (Untitled2)

  • NUM — number — Primary key — NOT NULL
  • ID — varchar2(64) — Foreign key → SPACEUSER.ID — NOT NULL
  • SUBJECT — varchar2(64)
  • READCOUNT — number
  • REGDATE — DATE
  • CONTENT — varchar2(2056)

SPACEUSER (Untitled)

  • ID — varchar2(64) — Primary key — NOT NULL
  • EMAIL — varchar2(128)
  • BIRTH — DATE
  • GENDER — char(1)
  • NAME — varchar2(64)
  • NICKNAME — varchar2(128)
  • PHONENUMBER — varchar2(128)

comment (Untitled3)

  • COMMENTNUM — number — Primary key — NOT NULL
  • NUM (NUM2) — number — Foreign key → SPACEBOARD.NUM — NOT NULL
  • ID — varchar2(64) — Foreign key → SPACEBOARD.ID — NOT NULL