Previous Topic: Data StructuresNext Topic: Data Columns and Indexes


Data Tables

Design Phase Tasks

P

E

Scoping Objects

Note

1. Add a new data table not associated with another data table.

M

 

M

D

 

D

Unimplemented entity type

Any data table

 

2. Add a new data table not associated with another data table.

M

 

M

D

S

Unimplemented entity type

Its associated entity types

1

3. Delete a data table not associated with another data table

D

D

Implemented entity type of target data table

1

4. Delete a data table associated with another data table.

D

D



M

M

D

D



D

S

(a) target data table

(b) data tables that have target data table's relationship membership name as their identifier

(c) implemented entity types for data tables in (a) & (b).

(d) any entity types to which the foreign key column of (a) & (b) point

 

Note: 1. An entity type scoped with Modify or Delete protection includes its associated data table at the same level of protection.