µ¥ÀÌÅͺ£À̽º Å×À̺í: STADDRESS


Å×ÀÌºí ¼³¸í:

ÀÌ Å×À̺íÀÇ °¢ ÇàÀº Á¤Àû ÁÖ¼Ò¸¦ Ç¥½ÃÇÕ´Ï´Ù. StoreEntities, FulfillmentCenters ¹× °ø±Þ¾÷ü°¡ Á¤Àû ÁÖ¼Ò¸¦ °¡Áú ¼ö ÀÖ½À´Ï´Ù. Á¤Àû ÁÖ¼Ò´Â ½ºÅ×ÀÌ¡ ¼­¹ö¸¦ »ç¿ëÇÏ¿© ½ºÅ×ÀÌ¡µÉ ¼ö ÀÖ½À´Ï´Ù.

¿­ ¼³¸í:

¿­ À̸§ ¿­ À¯Çü ¿­ ¼³¸í
ADDRESS1 VARCHAR (50)
NULL
»óÁ¡ ÁÖ¼Ò Çà 1.
ADDRESS2 VARCHAR (50)
NULL
»óÁ¡ ÁÖ¼Ò Çà 2.
ADDRESS3 VARCHAR (50)
NULL
»óÁ¡ ÁÖ¼Ò Çà 3.
BUSINESSTITLE VARCHAR (128)
NULL
»ç¿ëÀÚ Á÷À§
CITY VARCHAR (128)
NULL
ÀÌ ÁÖ¼Ò ³»ÀÇ ±¸/±º/½Ã
COUNTRY VARCHAR (128)
NULL
ÀÌ ÁÖ¼Ò ³»ÀÇ ±¹°¡
EMAIL1 VARCHAR (254)
NULL
ÀüÀÚ ¿ìÆí (2) ÁÖ¼Ò
EMAIL2 VARCHAR (254)
NULL
ÀüÀÚ ¿ìÆí (2) ÁÖ¼Ò
FAX1 VARCHAR (32)
NULL
ÆÑ½º ¹øÈ£ (1)
FAX2 VARCHAR (32)
NULL
ÆÑ½º ¹øÈ£(2)
FIELD1 VARCHAR (64)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIELD2 VARCHAR (64)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIELD3 VARCHAR (64)
NULL
»ç¿ëÀÚ Á¤ÀÇ °¡´É
FIRSTNAME VARCHAR (128)
NULL
´ã´çÀÚ À̸§
LASTNAME VARCHAR (128)
NULL
´ã´çÀÚ ¼º
MEMBER_ID BIGINT
NOT NULL
ÀÌ Ç׸ñ¿¡ ´ëÇÑ ¼ÒÀ¯ÀÚ ID
MIDDLENAME VARCHAR (128)
NULL
´ã´çÀÚ Áß°£ À̸§
NICKNAME VARCHAR (254)
NOT NULL
ÁÖ¼Ò¿¡ ´ëÇÑ º°¸í ¹× ½Äº°ÀÚ. º°¸íÀº °¢ »óÁ¡¿¡ ´ëÇØ °íÀ¯ÇØ¾ß ÇÕ´Ï´Ù.
PERSONTITLE VARCHAR (50)
NULL
´ã´çÀÚ Á÷À§
PHONE1 VARCHAR (32)
NULL
ÀüÈ­¹øÈ£ (1)
PHONE2 VARCHAR (32)
NULL
ÀüÈ­¹øÈ£ (2)
SHIPPINGGEOCODE VARCHAR (254)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
STADDRESS_ID INTEGER
NOT NULL
»ý¼ºµÈ °íÀ¯ Ű
STATE VARCHAR (128)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
TAXGEOCODE VARCHAR (254)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à
ZIPCODE VARCHAR (40)
NULL
IBM ³»ºÎ¿ëÀ¸·Î ¿¹¾à

»öÀÎ:

»öÀÎ À̸§ »öÀÎµÈ ¿­ À̸§ »öÀÎ À¯Çü
I0000231 MEMBER_ID, NICKNAME °íÀ¯ »öÀÎ
SQL020206020747410 STADDRESS_ID 1Â÷ Ű

Á¦ÇÑ»çÇ×:

Á¦ÇÑÀÚ À̸§ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_757 MEMBER_ID MEMBER MEMBER_ID °è´Ü½Ä


ÂüÁ¶:

Á¦ÇÑÀÚ À̸§ ÂüÁ¶µÈ ¿­ À̸§ Foreign Å×À̺í À̸§ Foreign ¿­ À̸§ Á¦ÇÑÀÚ À¯Çü
F_314 STADDRESS_ID FFMCENTDS STADDRESS_ID °è´Ü½Ä
F_791 STADDRESS_ID STOREENTDS STADDRESS_ID_CONT °è´Ü½Ä
F_792 STADDRESS_ID STOREENTDS STADDRESS_ID_LOC °è´Ü½Ä
F_902 STADDRESS_ID VENDORDESC STADDRESS_ID °è´Ü½Ä
IBM copyright