"Springmvc+mybatis project" Jie Xin Business-3. Requirements Analysis and database modeling

Development steps
Requirements: Manufacturer Information Maintenance base table Factory_c

1. Business Requirements:
A) "Requirements specification"
1) Describe business functions
Manufacturer Module
Function: For goods in the purchase and Sale contract module information and accessories information they have their own manufacturers.

b) "Summary design"
1) detailed description of business functions
2) Table Form database table (table + field + description)

c) Manufacturer Information Maintenance base table Factory_c
Function: For goods in the purchase and Sale contract module information and accessories information they have their own manufacturers.
Ordinal Chinese name English name type (length) remark
1. Ref. FACTORY_ID VARCHAR2 (+) UUID
2. Full name Full_name VARCHAR2 (200) According to the customer said the maximum length, compared to the length of the blur, on his basis, 2 to 4 times times
3. Abbreviation Factory_name VARCHAR2 (50)
4. Contact Contacts VARCHAR2 (30) 20/30
5. Telephone phone VARCHAR2 (20)
6 Mobile VARCHAR2 (20)
7. Fax VARCHAR2 (20)
8. Remarks Cnote VARCHAR2 (2000) when it feels like it might conflict with a keyword, add a c prefix
9. Inspector Inspector VARCHAR2 (30)
10. Sort number Order_no INT
11. Founder Create_by VARCHAR2 (40) ID of the current login
12. Create a department create_dept VARCHAR2 (40) The current login department
13. Creation Time Create_time TIMESTAMP

d) Primary key policy
1) Self-increment type Int/long speed fast
2) The UUID string is slow (it is recommended to use UUID, the primary key will not conflict when the distributed data is merged)

2.PD Database Modeling
First we modeled our team database, and we used the PowerDesigner.
We create a new model, select model types, select the physical Data Model, and select the DBMS (that is, which database the build statement was built after we modeled), we select Oracle Version 10g.


After that, we'll create the details of our table.

After the creation of a good effect:

Here we get the build statement that PowerDesigner gave us and start building the table in the database:

How to get

Database building tables using the obtained SQL build table statements

Click New in the PL/SQL developer, click on the Windows, copy the SQL statement you just made, click on the Yellow gear (run SQL statement) to build the table success!

"Springmvc+mybatis project" Jie Xin Business-3. Requirements Analysis and database modeling