[NexusDB] Table Script

CREATE TABLE M_MESSAGE
(
       UID VARCHAR(50) NOT NULL PRIMARY KEY,
       SenderID VARCHAR(15) NOT NULL,
       ReceiverID VARCHAR(15) NOT NULL,
       ReceiverText VARCHAR(8000) NOT NULL,
       SenderDelete CHAR(1) DEFAULT 'N',
       ReceiverDelete CHAR(1)  DEFAULT 'N',
       Message NVARCHAR(8000),
       MessageText VARCHAR(8000),
       Width INT,
       Height INT,
       Read CHAR(1) DEFAULT 'N',
       CreateDate DATETIME DEFAULT CURRENT_TIMESTAMP              
)

CREATE TABLE M_MEMBER_MAST
(
 UID AUTOINC NOT NULL PRIMARY KEY,
 UserID VARCHAR(15) NOT NULL,
 Password VARCHAR(15) DEFAULT '1234',
 UserName VARCHAR(50) NOT NULL,
 Level CHAR(1) DEFAULT '0',
 Mobile VARCHAR(50),
 Email VARCHAR(50),
 IP VARCHAR(50),
 IP2 VARCHAR(50),
 OS VARCHAR(50),
 EnterDate DATETIME,
 LeaveDate DATETIME,
 LoginDate DATETIME,
 LogoutDate DATETIME,
 DeleteFlag CHAR(1) DEFAULT 'N',
 Status CHAR(1) DEFAULT '0',
 CreateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 Creater VARCHAR(15),
 UpdateDate DATETIME DEFAULT CURRENT_TIMESTAMP  
)

CREATE TABLE M_MEMBER_INFO
(
 UID AUTOINC NOT NULL PRIMARY KEY,
 UserID varchar(15) not null,
 DeptUID BIGINT,
 PositionUID bigint,
 Intro varchar(100) default '안녕하세요',
 Sex char(1) default 'U',
 CreateDate DATETIME,
 Creater varchar(15),
 UpdateDate DATETIME,
 Updater varchar(15)
)

CREATE TABLE M_POSITION_MAST
(
 UID AUTOINC NOT NULL CONSTRAINT PK_M_POSITION_MAST PRIMARY KEY,
 Title VARCHAR(50) NOT NULL,
 SortID SMALLINT NOT NULL,
 DeleteFlag CHAR(1) DEFAULT 'N',
 CreateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 Creater VARCHAR(15),
 UpdateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 Updater VARCHAR(15)
)



CREATE TABLE M_BOOK_MARK
(
 UID AUTOINC NOT NULL PRIMARY KEY,
 UserID VARCHAR(15) NOT NULL,
 Type CHAR(3) NOT NULL,
 Title VARCHAR(50) NOT NULL,
 Value VARCHAR(8000) NOT NULL,
 CreateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 UpdateDate DATETIME DEFAULT CURRENT_TIMESTAMP
)


CREATE TABLE M_DEPT_MAST
(
 UID AUTOINC NOT NULL PRIMARY KEY,
 ParentUID BIGINT NOT NULL,
 Title VARCHAR(50) NOT NULL,
 SortID SMALLINT NOT NULL,
 DeleteFLag CHAR(1) DEFAULT 'N',
 CreateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 Creater VARCHAR(15),
 UpdateDate DATETIME DEFAULT CURRENT_TIMESTAMP,
 Updater VARCHAR(15)
)