Database Answers Header Fishing Boat in Fog, Alaska
Data Model for Web Site Pages
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

A Physical Data Model is shown on this page, and a Conceptual Model is also available ...
At the bottom of this page, there are also SQL Scripts to create the Pieces_of_Text Table and the associated Reference Table.

Physical Data Model for Web Site Pages
create table REF_PIECE_OF_TEXT_TYPES
(   PIECE_OF_TEXT_TYPE_CODE         CHAR(10)               not null,
    PIECE_OF_TEXT_TYPE_DESCRIPTION  VARCHAR2(50)           null   
)
/

create table PIECES_OF_TEXT
(   PIECE_OF_TEXT_ID                INT                    not null,
    PIECE_OF_TEXT_CODE              CHAR(10)               null    ,
    PIECE_OF_TEXT_TYPE_CODE         CHAR(10)               null    ,
    PARENT_PIECE_OF_TEXT_ID         INT                    null    ,
    PIECE_OF_TEXT_CONTENT           LONG                   null    ,
    constraint PK_PIECES_OF_TEXT primary key (PIECE_OF_TEXT_ID)
)/

Barry Williams
Principal Consultant
Database Answers


[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001