HTML and CSS Reference
In-Depth Information
Table 13-4. USER_GROUP Entity
Attribute name
Logical Type
Nullable
Description
ID
Integer
Primary Key (NOT NULL)
Auto-generated ID
USER_ID
String(32)
NOT NULL
Foreign key that represents the user ID
GROUP_ID
String(32)
NOT NULL
The group ID. It has one of two values:
1, which represents “User” group
2 which represents “Administrator” group
Listing 13-1 shows the equivalent SQL DDL (Data Definition Language) script of the indicated logical data model
for Java DB.
Listing 13-1. Mega App SQL DDL Script
-- Create Table: USER_GROUP
--------------------------------------------------------------------------------
CREATE TABLE USER_GROUP
( ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
, USER_ID VARCHAR(64)
, "GROUP_ID" INTEGER
);
-- Create Table: BOOK
--------------------------------------------------------------------------------
CREATE TABLE BOOK
(
ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1)
,ISBN VARCHAR(64) NOT NULL
,TITLE VARCHAR(128) NOT NULL
,AUTHOR VARCHAR(128) NOT NULL
,PUBLISHER VARCHAR(64) NOT NULL
,LANG VARCHAR(64) NOT NULL
,CONTENT blob(1M) NOT NULL
);
-- Create Table: MEGA_USER
--------------------------------------------------------------------------------
CREATE TABLE MEGA_USER
(
ID VARCHAR(64) NOT NULL PRIMARY KEY
,FIRST_NAME VARCHAR(32) NOT NULL
,LAST_NAME VARCHAR(32) NOT NULL
,PASSWORD VARCHAR(32) NOT NULL
);
 
Search WWH ::




Custom Search