请教问题

02-11-07 lsp1978

站长:

你好,能否同我讲解一下JIVE中的几个表的字段作用

CREATE TABLE jiveGroup (

groupID INT NOT NULL,

name VARCHAR(100) NOT NULL,

description VARCHAR(255) NULL,

modifiedDate CHAR(15) NOT NULL,

creationDate CHAR(15) NOT NULL,

);

CREATE TABLE jiveGroupPerm (

forumID INT NOT NULL,

groupID INT NOT NULL,

permission INT NOT NULL,);

CREATE TABLE jiveGroupProp (

groupID INT NOT NULL,

name VARCHAR(100) NOT NULL,

propValue TEXT NOT NULL,

);

CREATE TABLE jiveGroupUser (

groupID INT NOT NULL,

userID INT NOT NULL,

administrator INT NOT NULL,

);