FSDAFF

Tables (9)

gage

  • agekey — NUMBER — Primary key — NOT NULL
  • locationkey — NUMBER — Foreign key → glocation.locationkey — NOT NULL
  • agevalue — NUMBER — NOT NULL

gcategory

  • dcategorykey — NUMBER — Primary key — NOT NULL
  • dcategoryname — VARCHAR2(50) — NOT NULL

gcategory2

  • scategorykey — NUMBER — Primary key — NOT NULL
  • dcategorykey — NUMBER — NOT NULL
  • scategoryname — VARCHAR2(50) — NOT NULL

ggroup

  • groupkey — NUMBER — Primary key — NOT NULL
  • groupname — VARCHAR2(60) — NOT NULL
  • userkey — NUMBER — NOT NULL
  • agekey — NUMBER — NOT NULL
  • wherekey — NUMBER — NOT NULL
  • categorykey — NUMBER — NOT NULL
  • groupinfo — VARCHAR2(300) — NOT NULL
  • groupdfile — VARCHAR2(100)
  • groupidorigin — VARCHAR2(100)
  • groupcfile — VARCHAR2(100)
  • groupcorigin — VARCHAR2(100)
  • groupprivate — CHAR(1) — NOT NULL
  • grouptype — CHAR(1) — NOT NULL
  • groupdate — DATE — NOT NULL
  • groupstatus — NUMBER — NOT NULL

ggroupboard

  • boardkey — NUMBER — Primary key — NOT NULL
  • groupkey — NUMBER — NOT NULL
  • boardname — VARCHAR2(50) — NOT NULL
  • boardtype — CHAR(1)
  • boardseq — NUMBER

ggroupmember

  • groupkey — NUMBER — Primary key — NOT NULL
  • userkey — NUMBER — Primary key — NOT NULL
  • groupnickname — VARCHAR2(30) — NOT NULL
  • usergrade — NUMBER — NOT NULL

glocation

  • locationkey — NUMBER — Primary key — NOT NULL
  • swhere — VARCHAR2(40) — NOT NULL
  • dwhere — VARCHAR2(40) — NOT NULL
  • locationkey (locationkey2) — NUMBER — Foreign key → glocation.locationkey — NOT NULL

gusers

  • userkey — NUMBER — Primary key — NOT NULL
  • userid — VARCHAR2(20) — NOT NULL
  • userpassword — VARCHAR2(30) — NOT NULL
  • userimagefile — VARCHAR2(100)
  • userimageorigin — VARCHAR2(100)
  • userage — NUMBER — NOT NULL
  • userlocation — NUMBER — NOT NULL
  • gender — CHAR(1) — NOT NULL
  • useremail — VARCHAR2(50) — NOT NULL
  • userjoindate — DATE — NOT NULL
  • useroptionadmin — CHAR(1) — NOT NULL
  • useroptiongroup — CHAR(1) — NOT NULL
  • userstatus — NUMBER — NOT NULL
  • userstatuscode — DATE
  • logintype — number — NOT NULL

requestCategory

  • requestKey — NUMBER — Primary key — NOT NULL
  • dname — VARCHAR2(50) — NOT NULL
  • sname — VARCHAR2(50)
  • userkey — NUMBER — NOT NULL