WACS: Database Schemas

create table models 
( modelno           number(6) primary key,
  mname             varchar2(40),
  mhair		    varchar2(15),
  mlength           varchar2(20),
  mtitsize          varchar2(10),
  mcupsize          char(1),
  meyes             varchar2(15),
  mrace		    varchar2(15),
  mattributes	    varchar2(60),
  maliases          varchar2(60),
  mdisting	    varchar2(80),
  musual            varchar2(60),
  mimage            varchar2(80),
  mbigimage	    varchar2(80),
  mstatus	    char(1),
  mrating           char(1),
  mpussy	    char(1),
  mflag		    char(1),
  mvideos           char(1),
  msolo             char(1),
  mstraight         char(1),
  mlesbian          char(1),
  mfetish           char(1),
  mother            char(1),
  mnsets            number(4),
  mnimages          number(7),
  mnvideos          number(4),
  mcountry          varchar2(30),
  mhometown	    varchar2(80),
  mage		    number(3),
  mageyear          number(4),
  mcstatus          char(1),
  mvitbust          number(4),
  mvitwaist         number(4),
  mvithips          number(4),
  mbuild            char(1),
  mheight           number(3),
  mweight           number(3),
  moccupation       varchar2(30),
  mcontact	    varchar2(80),
  mnotes	    varchar2(240),
  madded            date,
  mamended	    date
);