Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version 3

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

USERS

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments

1

ID

NUMBER

22

N

 Primary key

2

ACCOUNT_ID

NUMBER

22

N

 Foreign key referencing ACCOUNT-table

3

COMPANY

VARCHAR2

255

1020

Y

  

4

FIRST_NAME

VARCHAR2

60

240

Y

  

5

LAST_NAME

VARCHAR2

60

240

Y

  

6

ADDRESS1

VARCHAR2

90

360

Y

  

7

ADDRESS2

VARCHAR2

90

360

Y

  

8

CITY

VARCHAR2

40

160

Y

  

9

ZIP

VARCHAR2

40

160

Y

  

10

COUNTRY

VARCHAR2

40

160

Y

  

11

PHONE1

VARCHAR2

20

80

Y

  

12

PHONE2

VARCHAR2

20

80

Y

  

13

PHONE3

VARCHAR2

20

80

Y

  

14

FAX

VARCHAR2

20

80

Y

  

15

EMAIL

VARCHAR2

120

480

Y

  

16

EMAIL2

VARCHAR2

120

480

Y

  

17

BIRTHDAY

DATE

7

Y

  

18

LAST_CHANGED_DATE

DATE

7

Y

  

19

ADVERTISE_EMAIL

NUMBER

22

Y

  

20

U_COMMENT

VARCHAR2

255

1020

Y

  

21

STATUS_ID

NUMBER

22

Y

  

22

USERNAME

VARCHAR2

100

400

Y

  

23

PASSWORD

VARCHAR2

100

400

Y

  

24

QUESTION

VARCHAR2

1000

4000

Y

  

25

ANSWER

VARCHAR2

1000

4000

Y

  

26

STREET

VARCHAR2

256

1024

Y

  

27

STREET_NUMBER

VARCHAR2

12

48

Y

  

28

FLOOR

VARCHAR2

12

48

Y

  

29

FLOOR_UNIT

VARCHAR2

32

128

Y

  

30

PERSONAL_ID

VARCHAR2

50

200

Y

  

31

STATE_ID

NUMBER

22

Y

  

32

ADDR_ID

VARCHAR2

50

200

Y

  

33

CONT_ID

VARCHAR2

40

160

Y

  

34

CREDIT_RATING

CHAR

VARCHAR2

1

4

Y

  

35

CREDIT_RATING_DATE

DATE

7

Y

  

36

CREDIT_SCORE

CHAR

VARCHAR2

1

4

Y

  

37

CREDIT_SCORE_DATE

DATE

7

Y

  

38

OVERRIDE_CREDIT_SCORE_UNTIL

DATE

7

Y

  

39

GENDER

CHAR

VARCHAR2

1

4

Y

  

40

CREDIT_LIMIT

NUMBER

22

Y

  

41

LANGUAGE_CODE

VARCHAR2

10

40

Y

  

42

REG_STATUS

CHAR

VARCHAR2

1

4

Y

  

43

ADDRESS_CHECK_DATE

DATE

7

Y

  

44

PROVINCE

VARCHAR2

60

240

Y

  

45

ADDRESS_PROOF

NUMBER

22

Y

  

46

COUNTY

VARCHAR2

50

200

Y

  

47

DISTRICT

VARCHAR2

50

200

Y

  

48

BUILDING

VARCHAR2

50

200

Y

  

49

LAST_NAME_PREFIX

VARCHAR2

40

160

Y

  

50

INITIALS

VARCHAR2

15

60

Y

  

51

TITLE

VARCHAR2

20

80

Y

  

52

BLACKLISTED

NUMBER

22

Y

  

53

OLI_ID

VARCHAR2

50

200

Y

  

54

BRAND_ID

NUMBER

22

Y

 Foreign key referencing BRAND-table

55

PERSONAL_ID_EXPIRY_DATE

DATE

7

Y

  

56

PERSONAL_ID_TYPE

VARCHAR2

30

120

Y

  

57

ADVERTISING

CHAR

VARCHAR2

1

4

Y

  

58

ADVERTISING_CUSTOMER_DATA

VARCHAR2

1

4

Y

  

59

ADVERTISING_USAGE_DATA

VARCHAR2

1

4

Y

  

60

COMMUNICATION_TYPE

CHAR

VARCHAR2

1

4

Y

  

61

ADVERTISE_SMS

NUMBER

22

Y

  

62

COMPANY_SUB_ID

VARCHAR2

120

Y

  

63

SHIPPING_ADDRESS_ID

NUMBER

22

Y

 ?

64

SHIPPING_ADDRESS_USER

CHAR

VARCHAR2

1

4

Y

 ?

65

INSTALLATION_ADDRESS

CHAR

VARCHAR2

1

4

Y

  

66

STREET_UNIT

VARCHAR2

48

Y

  

67

CONCURRENCY_KEY

NUMBER

22

Y

  

68

ACCESS_LEVEL

NUMBER

22

Y

  

69

VAT_NUMBER

VARCHAR2

400

Y

  

70

DIRECTION

VARCHAR2

40

Y

  

71

ZIP_EXT

VARCHAR2

40

Y

  

72

ADDRESS_STATE

VARCHAR2

40

Y

  

73

PO_BOX

VARCHAR2

160

Y

  

74

CA_UCN

NATIONALITY

VARCHAR2

400

Y

  
75

CA_SEGMENT_TYPE

VARCHAR2

400

Y

  
76

CA_KYC_PENDING

VARCHAR2

4

Y

  
77

CA_VIP

VARCHAR2

4

12

Y

  
Column
width33%

Contains all Users