-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathmetadata.txt
126 lines (107 loc) · 5.92 KB
/
metadata.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
// GENERATED FILE, DO NOT MODIFY! YOUR MODIFICATION WILL BE LOST!
#
# Information about database.
#
# Created on: Nov 25, 2015 5:59:20 PM
# Database name: sampledb
# Generated by easydao-maven-plugin v2.0.2-SNAPSHOT
#
# There are four sections:
# SECTION 1: Help for creating replacement files
# SECTION 2: Metadata about database.
# SECTION 3: There is no primary key in these tables
# SECTION 4: There is no sequence for the primary key of these tables
# SECTION 5: Count tables and fields
#
#
# SECTION 1: Help for creating replacement files
#
# Helper data for replacement property file.
# You can insert these table and filed names into replacement files.
#
# If you don't want a table in your model, then insert into
# replacement-table.properties file:
#
# TABLE_NAME =
#
# If you want this table with another name in your model, then insert:
#
# TABLE_NAME = MyNewModelName
#
# Class name will be generated as MyNewModelName.java
#
# If you don't want a field in your model, then insert into
# replacement-field.properties file:
#
# TABLE_NAME.FIELD_NAME =
#
# If you want this field with another name in your model, then insert:
#
# TABLE_NAME.FIELD_NAME = myNewFieldName
#
# So it will be generated as: private String myNewFieldName;
#
# TABLE names for replacement file:
#
adr_address =
cus_customer =
#
# FIELD names for replacement file:
#
adr_address.adr_pk =
adr_address.adr_street =
adr_address.adr_locality =
adr_address.adr_postal_code =
adr_address.adr_country =
adr_address.adr_locked =
adr_address.adr_modificaton_ts =
cus_customer.cus_pk =
cus_customer.cus_adr_pk =
cus_customer.cus_name =
cus_customer.cus_email =
cus_customer.cus_type =
cus_customer.cus_reg_ts =
cus_customer.cus_locked =
cus_customer.cus_modificaton_ts =
#
# SECTION 2: Metadata about database.
#
#
# TABLES
#
TABLE NAME JAVA NAME FIELDS COMMENT
adr_address Address 7 Address table
cus_customer Customer 8 Customer table
#
# FIELDS
#
TABLE.FIELD NAME JAVA NAME DB TYPE JAVA TYPE PK NULLABLE ARRAY COMMENT
adr_address.adr_pk pk numeric(10,0) Long true false false Address unique ID
adr_address.adr_street street character varying(90) String false false false Address street part: HOUSE_NUMBER STREET_NAME [STREET_TYPE] [STREET_DIRECTION] [BUILDING] [FLOOR] [APARTMENT]
adr_address.adr_locality locality character varying(40) String false false false Adress locality, e.g: WASHINGTON DC
adr_address.adr_postal_code postalCode character(20) String false false false FIXME: Warning: There is no comment in database!
adr_address.adr_country country character(40) String false true false Address CountryT
adr_address.adr_locked locked boolean Boolean false true false Customer has locked
adr_address.adr_modificaton_ts modificatonTs timestamp without time zone Timestamp false true false Address record modification date
cus_customer.cus_pk pk numeric(10,0) Long true false false Customer unique ID
cus_customer.cus_adr_pk addressPk numeric(10,0) Long false false false FIXME: Warning: There is no comment in database!
cus_customer.cus_name name character varying(90) String false false false Customer name
cus_customer.cus_email email character varying(60) String false false false FIXME: Warning: There is no comment in database!
cus_customer.cus_type type character(30) String false false false Customer type: RETAIL, WHOLESALE, GOVERNMENT
cus_customer.cus_reg_ts regTs timestamp without time zone Timestamp false true false Customer registration timestamp
cus_customer.cus_locked locked boolean Boolean false true false Customer has locked
cus_customer.cus_modificaton_ts modificatonTs timestamp without time zone Timestamp false true false Customer record modification date
#
# SECTION 3: There is no primary key in these tables
#
TABLE NAME JAVA NAME COMMENT
#
# SECTION 4: There is no sequence for the primary key of these tables
#
TABLE NAME SEQUENCE NAME
adr_address adr_address_SEQ
cus_customer cus_customer_SEQ
#
# SECTION 5: Count tables and fields
#
There are 2 tables and 15 fields in the database.