Summary of the Magic Operation database Building table

M agic Creating a table summary

Magic Creation Table (database Oracle for example)

First create the project:

File--new Project (project name)--(Local Files folder pick path)

You need to establish a connection to the database after you create the project:

Create a project page (menu bar opens the database repository)--CTRL+F4 (add a new line) (name name, database name specified by the database name) Conveniently specify which database to identify (DBMS connection database type)--establish which user under--properties (shortcut key is Alt+enter) setting property--database Server (server name)--user name username--user Password Password

The table needs to be created after the connection is established:

Double-click the project --data in the table--name (identifier), (Data source Name table name) [Table name naming convention is: module name +_***,...] --Table Property properties (shortcut key is Alt+enter)--cache strategy cache policy--set to None--sql (check exis tence Verify existence set to Yes)--columns--build field

Rules for creating fields:

set the field name rule:

1 All letters capitalized

2 field names to reflect the meaning of the field

3 Field name cannot be a keyword subtype

Attribute setting the field type:

Alpha character types are stored in the database as Char

Numeric number type (with fractional digits before adding n)

Date Date type (set in NULL in value format: 00/00/0000)

The looical logical type (true/flase) is stored in the database as a numeric type with 0/1 differences

Blob binary

Time is the corresponding char type in the database

When you create the drop looical can all be in the attribute:

Null all owed change to Yes

Null default change to Yes

Picture Set length

Model Template

left models (set Name,attrbutes,picture)

More for the same fields, attributes in the table

No primary key in magic but unique index

To create a unique index:

Indexes--name (rule: First Letter of table name _ field)--Property properties (shortcut key is Alt+enter)--sql--clustered change to YES--DB index name to set name

Create the table created by the magic to the database:

Ctel+g

if the field of the Magic table is different from the database setting properties: DB Column name corresponds to

Index If you have created a change, check that the DB index name in SQL in the property corresponds to

Add data manually:ctrl+g input Information-write good ctrl+q save--ctrl+m Modify

Summary of the Magic Operation database Building table