[thesite] Members' Directory/Pages

[Michele Foster]

Rudy,

I have a couple of questions.

(1)  Why is PRIV on both member and membattr tables?  I thought we only
needed one PRIV?  I know what the values are for the "member" table, but
what are the proposed values for the membattr table and how do they differ?
(not sure if this can be discussed on here or not, if the answer is simply
they will be different, they are both required, that's fine)

(2)  What is SEQ on the membattr table?

(3)  What are REMARKS for?  Will the member be able to use this field?  and
if so, umm.. what's its intended use, that it won't be an attribute already
defined?

(4)  Are ATTRVALUE and REMARKS set to be 255 characters?  (Is that what it
means in Oracle?)  i.e. a text field not a memo field (Access terms).  What
about making Remarks a memo field (clob?), then members can enter a
description, more info, etc. than that defined by an attribute.  (Hi, I'm
joe user from Toronto, Ontario, I'm 33, single male, never been married,
yadda, yadda <G>)

If we want to go one step further and incorporate Joshua's resume builder,
that will require additional memo (clob??) fields?  Feasibility?

One final question, do you have a list of attributes already created?

Thanks,

Michele


----- Original Message -----
From: "rudy" <r937 at interlog.com>

|
| SQL> describe member
| Name                            Null?    Type
| ------------------------------- -------- ----
| MEMBERID                        NOT NULL NUMBER(8)
| CREATEDATE                      NOT NULL DATE
| DATEMOD                         NOT NULL DATE
| FIRSTNAME                       NOT NULL VARCHAR2(50)
| LASTNAME                        NOT NULL VARCHAR2(50)
| PRIV                            NOT NULL NUMBER(1)
| ACTIVE                          NOT NULL NUMBER(1)
|
| SQL> describe attribute
| Name                            Null?    Type
| ------------------------------- -------- ----
| ATTRID                          NOT NULL NUMBER(8)
| ATTRNAME                        NOT NULL VARCHAR2(50)
|
| SQL> describe membattr
| Name                            Null?    Type
| ------------------------------- -------- ----
| MEMBATTRID                      NOT NULL NUMBER(8)
| MEMBERID                        NOT NULL NUMBER(8)
| ATTRID                          NOT NULL NUMBER(8)
| SEQ                             NOT NULL NUMBER(2)
| PRIV                            NOT NULL NUMBER(1)
| ATTRVALUE                                VARCHAR2(255)
| REMARKS                                  VARCHAR2(255)
|