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