Database Answers Header Fishing Boat in Fog, Alaska
Data Model for User Tables
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  
Back to the Conceptual Data Model, and an Access Database is available on demand.

Data Model for Users in a Data Dictionary

Here's the Script to create the Tables in Oracle ...
 
CREATE TABLE DD_Users(
 user_id         INTEGER PRIMARY KEY,
 user_login_name VARCHAR2(30),
 user_category   CHAR(15),
 user_registration_date DATE,
 user_email      VARCHAR2(80),
 user_country    VARCHAR2(80),
 user_language   VARCHAR2(80))
/

CREATE VIEW VW_Users AS
SELECT
user_login_name ,
user_category   ,
user_registration_date,
user_country    ,
user_language   ,
user_email 
FROM  table_name -- eg dd_users
/


INSERT INTO dd_Users
(user_id,user_login_name,user_category,user_registration_date,user_email,user_country,user_language) 
VALUES (1,'JoeB','BASIC','01-Jan-2003','joebloggs@ukmail.com','UK','English')
/

INSERT INTO dd_Users
(user_id,user_login_name,user_category,user_registration_date,user_email,user_country,user_language) 
VALUES (2,'JohnD','Q-BASIC','03-Jan-2003','john.doe@usmail.com','USA','English')
/

Barry Williams
Principal Consultant
Database Answers


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

© DatabaseAnswers.com 2004