CREATE TABLE T_FDDB_COURSE
(
    F_COURSEID                     INT NOT NULL,
    F_COURSENAME                   NVARCHAR(128) NULL,
    F_BEGDA                        CHAR(8) NULL,
    F_ENDDA                        CHAR(8) NULL,
    F_PARTDETAIL                   VARCHAR(512) NULL,
    F_COSTDETAIL                   VARCHAR(512) NULL,
    F_HALLID                       INT NULL,
    F_GROUPID                      INT NULL,
    F_COUNT                        INT NULL
)
go
ALTER TABLE T_FDDB_COURSE
    ADD PRIMARY KEY CLUSTERED (F_COURSEID)
go
CREATE TABLE T_FDDB_DANCE
(
    F_DANCEID                      INT NOT NULL,
    F_DANCENAME                    NVARCHAR(128) NOT NULL,
    F_ALPHANAME                    VARCHAR(128) NULL,
    F_ORGNNAME                     NVARCHAR(128) NULL,
    F_GAINAME                      NVARCHAR(128) NULL,
    F_KANANAME                     VARCHAR(128) NULL,
    F_TEACHERID                    INT NOT NULL,
    F_LOCATEID                     INT NOT NULL,
    F_DANCEFORMID                  INT NULL,
    F_RHYTHMID                     INT NULL,
    F_MEMO                         VARCHAR(1024) NULL,
    F_COUNT                        INT NULL
)
go
ALTER TABLE T_FDDB_DANCE
    ADD PRIMARY KEY CLUSTERED (F_DANCEID)
go
CREATE TABLE T_FDDB_DANCECOURSE
(
    F_DANCEID                      INT NOT NULL,
    F_COURSEID                     INT NOT NULL,
    F_TEACHERID                    INT NULL,
    F_DATE                         CHAR(8) NULL,
    F_ORGNFLG                      CHAR(1) NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCECOURSE
    ADD PRIMARY KEY CLUSTERED (F_DANCEID, F_COURSEID)
go
CREATE TABLE T_FDDB_DANCEFORM
(
    F_DANCEFORMID                  INT NOT NULL,
    F_DANCEFORMTEXT                VARCHAR(128) NULL,
    F_DANCESEX                     VARCHAR(32) NULL
)
go
ALTER TABLE T_FDDB_DANCEFORM
    ADD PRIMARY KEY CLUSTERED (F_DANCEFORMID)
go
CREATE TABLE T_FDDB_DANCEMEETING
(
    F_DANCEID                      INT NOT NULL,
    F_MEETINGID                    INT NOT NULL,
    F_COURSEFLG                    VARCHAR(8) NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCEMEETING
    ADD PRIMARY KEY CLUSTERED (F_DANCEID, F_MEETINGID)
go
CREATE TABLE T_FDDB_DANCEMUSIC
(
    F_DANCEID                      INT NOT NULL,
    F_MUSICID                      INT NOT NULL,
    F_PATH                         VARCHAR(256) NOT NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCEMUSIC
    ADD PRIMARY KEY CLUSTERED (F_MUSICID, F_DANCEID)
go
CREATE TABLE T_FDDB_DANCEPARTY
(
    F_DANCEID                      INT NOT NULL,
    F_PARTYID                      INT NOT NULL,
    F_FLG                          CHAR(1) NULL,
    F_PARTNAME                     VARCHAR(32) NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCEPARTY
    ADD PRIMARY KEY CLUSTERED (F_PARTYID, F_DANCEID)
go
CREATE TABLE T_FDDB_DANCETEXT
(
    F_DANCEID                      INT NOT NULL,
    F_TEXTID                       INT NOT NULL,
    F_PATH                         VARCHAR(256) NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCETEXT
    ADD PRIMARY KEY CLUSTERED (F_TEXTID, F_DANCEID)
go
CREATE TABLE T_FDDB_DANCEVIDEO
(
    F_DANCEID                      INT NOT NULL,
    F_VIDEOID                      INT NOT NULL,
    F_PATH                         VARCHAR(256) NULL,
    F_SORTNUM                      INT NULL
)
go
ALTER TABLE T_FDDB_DANCEVIDEO
    ADD PRIMARY KEY CLUSTERED (F_DANCEID, F_VIDEOID)
go
CREATE TABLE T_FDDB_GROUP
(
    F_GROUPID                      INT NOT NULL,
    F_GROUPNAME                    NVARCHAR(64) NOT NULL,
    F_BEGDA                        CHAR(8) NULL,
    F_ENDDA                        CHAR(8) NULL,
    F_LOCATEID                     INT NULL
)
go
ALTER TABLE T_FDDB_GROUP
    ADD PRIMARY KEY CLUSTERED (F_GROUPID)
go
CREATE TABLE T_FDDB_LOCATE
(
    F_LOCATEID                     INT NOT NULL,
    F_LOCATENAME                   NVARCHAR(128) NOT NULL,
    F_COUNTRY                      NVARCHAR(32) NULL,
    F_DISTRICT                     NVARCHAR(32) NULL,
    F_AREA                         NVARCHAR(64) NULL
)
go
ALTER TABLE T_FDDB_LOCATE
    ADD PRIMARY KEY CLUSTERED (F_LOCATEID)
go
CREATE TABLE T_FDDB_HALL
(
    F_HALLID                       INT NOT NULL,
    F_HALLNAME                     VARCHAR(128) NOT NULL,
    F_LOCATEID                     INT NULL,
    F_ADDRESS                      VARCHAR(256) NULL,
    F_LOADTO                       VARCHAR(512) NULL
)
go
ALTER TABLE T_FDDB_HALL
    ADD PRIMARY KEY CLUSTERED (F_HALLID)
go
CREATE TABLE T_FDDB_MEETING
(
    F_MEETINGID                    INT NOT NULL,
    F_MEETINGNAME                  NVARCHAR(64) NOT NULL,
    F_DATE                         CHAR(8) NULL,
    F_BEGTIME                      CHAR(4) NULL,
    F_ENDTIME                      CHAR(4) NULL,
    F_COST                         VARCHAR(5) NULL,
    F_HALLID                       INT NULL,
    F_GROUPID                      INT NULL,
    F_COUNT                        INT NULL
)
go
ALTER TABLE T_FDDB_MEETING
    ADD PRIMARY KEY CLUSTERED (F_MEETINGID)
go
CREATE TABLE T_FDDB_MUSIC
(
    F_MUSICID                      INT NOT NULL,
    F_MUSICNAME                    NVARCHAR(128) NULL,
    F_PRICE                        VARCHAR(5) NULL,
    F_MEDIAFLG                     VARCHAR(8) NULL,
    F_ORGNFLG                      CHAR(1) NULL,
    F_WRITING                      VARCHAR(64) NULL
)
go
ALTER TABLE T_FDDB_MUSIC
    ADD PRIMARY KEY CLUSTERED (F_MUSICID)
go
CREATE TABLE T_FDDB_PARTY
(
    F_PARTYID                      INT NOT NULL,
    F_PARTYNAME                    NVARCHAR(128) NOT NULL,
    F_DATE                         CHAR(8) NULL,
    F_BEGTIME                      CHAR(4) NULL,
    F_ENDTIME                      CHAR(4) NULL,
    F_COST                         VARCHAR(5) NULL,
    F_GROUPID                      INT NOT NULL,
    F_HALLID                       INT NOT NULL,
    F_COUNT                        INT NULL
)
go
ALTER TABLE T_FDDB_PARTY
    ADD PRIMARY KEY CLUSTERED (F_PARTYID)
go
CREATE TABLE T_FDDB_RHYTHM
(
    F_RHYTHMID                     INT NOT NULL,
    F_RHYTHMTEXT                   VARCHAR(128) NULL
)
go
ALTER TABLE T_FDDB_RHYTHM
    ADD PRIMARY KEY CLUSTERED (F_RHYTHMID)
go
CREATE TABLE T_FDDB_TEXT
(
    F_TEXTID                       INT NOT NULL,
    F_TEXTNAME                     NVARCHAR(128) NULL,
    F_FLG                          VARCHAR(8) NULL,
    F_ORGNFLG                      CHAR(1) NULL,
    F_PRICE                        VARCHAR(5) NULL,
    F_WRITING                      NVARCHAR(64) NULL
)
go
ALTER TABLE T_FDDB_TEXT
    ADD PRIMARY KEY CLUSTERED (F_TEXTID)
go
CREATE TABLE T_FDDB_TEACHER
(
    F_TEACHERID                    INT NOT NULL,
    F_TEACHERNAME                  NVARCHAR(64) NOT NULL,
    F_LOCATEID                     INT NOT NULL,
    F_BORNDATE                     CHAR(8) NULL,
    F_LIVING                       CHAR(1) NULL
)
go
ALTER TABLE T_FDDB_TEACHER
    ADD PRIMARY KEY CLUSTERED (F_TEACHERID)
go
CREATE TABLE T_FDDB_UPDATELOG
(
    F_DATE                         DATETIME NOT NULL,
    F_TEXT                         NVARCHAR(512) NULL
)
go
ALTER TABLE T_FDDB_UPDATELOG
    ADD PRIMARY KEY CLUSTERED (F_DATE)
go
CREATE TABLE T_FDDB_VIDEO
(
    F_VIDEOID                      INT NOT NULL,
    F_VIDEONAME                    NVARCHAR(128) NOT NULL,
    F_PRICE                        VARCHAR(5) NULL,
    F_MEDIAFLG                     VARCHAR(8) NULL,
    F_ORGNFLG                      CHAR(1) NULL,
    F_WRITING                      NVARCHAR(64) NULL
)
go
ALTER TABLE T_FDDB_VIDEO
    ADD PRIMARY KEY CLUSTERED (F_VIDEOID)
go
CREATE TABLE T_FDDB_LOG
(
    F_DATE                         DATETIME NULL,
    F_UPTGT                        VARCHAR(32) NULL,
    F_UPOPT                        VARCHAR(16) NULL,
    F_UPDETAIL                     NVARCHAR(256) NULL
)
go
CREATE TABLE T_FDDB_DANCECMT
(
    F_DANCEID                      INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_MUSICCMT
(
    F_MUSICID                      INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_VIDEOCMT
(
    F_VIDEOID                      INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_TEXTCMT
(
    F_TEXTID                       INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_MEETINGCMT
(
    F_MEETINGID                    INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_PARTYCMT
(
    F_PARTYID                      INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_COURSECMT
(
    F_COURSEID                     INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_GROUPCMT
(
    F_GROUPID                      INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
CREATE TABLE T_FDDB_TEACHERCMT
(
    F_TEACHERID                    INT NULL,
    F_UPDATE                       DATETIME NULL,
    F_COMMENT                      NVARCHAR(1024) NULL
)
go
ALTER TABLE T_FDDB_DANCECOURSE
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEPARTY
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEVIDEO
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEMUSIC
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCETEXT
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEMEETING
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCE
    ADD FOREIGN KEY(F_TEACHERID) REFERENCES T_FDDB_TEACHER (F_TEACHERID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCECOURSE
    ADD FOREIGN KEY(F_TEACHERID) REFERENCES T_FDDB_TEACHER (F_TEACHERID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCE
    ADD FOREIGN KEY(F_LOCATEID) REFERENCES T_FDDB_LOCATE (F_LOCATEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_TEACHER
    ADD FOREIGN KEY(F_LOCATEID) REFERENCES T_FDDB_LOCATE (F_LOCATEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_HALL
    ADD FOREIGN KEY(F_LOCATEID) REFERENCES T_FDDB_LOCATE (F_LOCATEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_COURSE
    ADD FOREIGN KEY(F_HALLID) REFERENCES T_FDDB_HALL (F_HALLID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_GROUP
    ADD FOREIGN KEY(F_LOCATEID) REFERENCES T_FDDB_LOCATE (F_LOCATEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_COURSE
    ADD FOREIGN KEY(F_GROUPID) REFERENCES T_FDDB_GROUP (F_GROUPID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEPARTY
    ADD FOREIGN KEY(F_PARTYID) REFERENCES T_FDDB_PARTY (F_PARTYID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_PARTY
    ADD FOREIGN KEY(F_GROUPID) REFERENCES T_FDDB_GROUP (F_GROUPID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_PARTY
    ADD FOREIGN KEY(F_HALLID) REFERENCES T_FDDB_HALL (F_HALLID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEMEETING
    ADD FOREIGN KEY(F_MEETINGID) REFERENCES T_FDDB_MEETING (F_MEETINGID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_MEETING
    ADD FOREIGN KEY(F_HALLID) REFERENCES T_FDDB_HALL (F_HALLID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_MEETING
    ADD FOREIGN KEY(F_GROUPID) REFERENCES T_FDDB_GROUP (F_GROUPID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCE
    ADD FOREIGN KEY(F_DANCEFORMID) REFERENCES T_FDDB_DANCEFORM (F_DANCEFORMID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCE
    ADD FOREIGN KEY(F_RHYTHMID) REFERENCES T_FDDB_RHYTHM (F_RHYTHMID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCETEXT
    ADD FOREIGN KEY(F_TEXTID) REFERENCES T_FDDB_TEXT (F_TEXTID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEVIDEO
    ADD FOREIGN KEY(F_VIDEOID) REFERENCES T_FDDB_VIDEO (F_VIDEOID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCEMUSIC
    ADD FOREIGN KEY(F_MUSICID) REFERENCES T_FDDB_MUSIC (F_MUSICID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_DANCECMT
    ADD FOREIGN KEY(F_DANCEID) REFERENCES T_FDDB_DANCE (F_DANCEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_MUSICCMT
    ADD FOREIGN KEY(F_MUSICID) REFERENCES T_FDDB_MUSIC (F_MUSICID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_VIDEOCMT
    ADD FOREIGN KEY(F_VIDEOID) REFERENCES T_FDDB_VIDEO (F_VIDEOID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_TEXTCMT
    ADD FOREIGN KEY(F_TEXTID) REFERENCES T_FDDB_TEXT (F_TEXTID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_MEETINGCMT
    ADD FOREIGN KEY(F_MEETINGID) REFERENCES T_FDDB_MEETING (F_MEETINGID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_PARTYCMT
    ADD FOREIGN KEY(F_PARTYID) REFERENCES T_FDDB_PARTY (F_PARTYID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_COURSECMT
    ADD FOREIGN KEY(F_COURSEID) REFERENCES T_FDDB_COURSE (F_COURSEID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_GROUPCMT
    ADD FOREIGN KEY(F_GROUPID) REFERENCES T_FDDB_GROUP (F_GROUPID) ON UPDATE NO ACTION ON DELETE NO ACTION
go
ALTER TABLE T_FDDB_TEACHERCMT
    ADD FOREIGN KEY(F_TEACHERID) REFERENCES T_FDDB_TEACHER (F_TEACHERID) ON UPDATE NO ACTION ON DELETE NO ACTION
go