# A5:ER FORMAT:04
# A5:ER ENCODING:Shift_JIS
# A5:ER Mk-1 Copyright (C)2007 m.matsubara
# A5:SQL Mk-2 Copyright (C)1997 m.matsubara
#  http://www.wind.sannet.ne.jp/m_matsu/developer/a5m2/

[Manager]
ProjectName=ショッピングサイト
Author=m.matsubara
MaxEntityRowShow=1000
ReadOnlyRecommend=0
Page=Main
Domain=お客様番号=@VARCHAR(10)
Domain=商品番号=@VARCHAR(10)
Domain=メーカーコード=@VARCHAR(10)
Domain=注文番号=@VARCHAR(10)
Domain=分類ID=@VARCHAR(10)
Domain=商品種別=@VARCHAR(2)
Domain=会員種別=@VARCHAR(2)
Domain=人名=@VARCHAR(30)
Domain=メーカー名=@VARCHAR(30)
Domain=商品名=@VARCHAR(30)
Domain=価格=@DECIMAL(10,0)
Domain=備考=@VARCHAR(100)
LogicalView=1
DecodeDomain=0
ViewMode=3
ViewFormat=0
UseNondependenceDashLine=0
FontName=Tahoma
FontSize=9
PaperSize=A4Landscape
HeaderLeft=
HeaderCenter=
HeaderRight=
FooterLeft=
FooterCenter=
FooterRight=
ShowPageoutRelation=1

[Shape]
Page=Main
Left=37
Top=42
Width=601
Height=111
LineColor=$FF0000
LineWidth=5
BrushColor=$FFFF00
BrushAlpha=128
ShapeType=RoundRect
Text=ショッピングサイト ER図
FontName=Tahoma
FontSize=16
FontColor=$FF0000
ImageFileName=

[Relation]
Entity1=MS_COMM_CLASS
Entity2=MS_COMM_CLASS
RelationType1=2
RelationType2=3
Fields1=CLASS_ID
Fields2=PARENT_CLASS_ID
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5110,3280,8130,R,R
Dependence=0
Caption=
PName=
LineMode=0
Bar1=511
Bar2=328
Bar3=813
TermPos1=R
TermPos2=R

[Relation]
Entity1=MS_COMM_CLASS
Entity2=MS_COMMODITY
RelationType1=2
RelationType2=3
Fields1=CLASS_ID
Fields2=CLASS_ID
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5050,5000,3000,R,R
Dependence=0
Caption=
PName=
LineMode=0
Bar1=505
Bar2=500
Bar3=300
TermPos1=R
TermPos2=R

[Entity]
PName=MS_COMM_CLASS
LName=商品分類マスタ
Comment=
TableOption=
Page=MAIN
Left=2150
Top=900
Field="分類ID","CLASS_ID","*分類ID","NOT NULL",0,"","",$FFFFFFFF
Field="分類名称","CLASS_NM","*商品名",,,"","",$FFFFFFFF
Field="親分類ID","PARENT_CLASS_ID","*分類ID",,,"","",$FFFFFFFF
EffectMode=None
Color=$FF0000
BkColor=$FFFFFF
Position="MAIN",2150,900

[Relation]
Entity1=MS_COMMODITY
Entity2=TB_ORDER_SUB
RelationType1=2
RelationType2=3
Fields1=COMM_ID
Fields2=COMM_ID
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4909,4370,4972,R,R
Dependence=0
Caption=
PName=
LineMode=0
Bar1=491
Bar2=437
Bar3=497
TermPos1=R
TermPos2=R

[Relation]
Entity1=TB_ORDER
Entity2=TB_ORDER_SUB
RelationType1=2
RelationType2=3
Fields1=ORDER_NO
Fields2=ORDER_NO
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5000,5000,5007,R,R
Dependence=1
Caption=
PName=
LineMode=0
Bar1=500
Bar2=500
Bar3=501
TermPos1=R
TermPos2=R

[Entity]
PName=TB_ORDER_SUB
LName=注文明細
Comment=
TableOption=
Page=MAIN
Left=1250
Top=800
Field="注文番号","ORDER_NO","*注文番号","NOT NULL",0,"","",$FFFFFFFF
Field="枝番","SUB_NO","@INT","NOT NULL",1,"","",$FFFFFFFF
Field="商品番号","COMM_ID","*商品番号",,,"","",$FFFFFFFF
Field="単価","UNITPRICE","*価格",,,"","",$FFFFFFFF
Field="数量","AMOUNT","@INT",,,"","",$FFFFFFFF
Field="納品済みフラグ","DELIVERY_FLAG","@CHAR(1)",,,"","",$FFFFFFFF
Field="納品日","DELIVERY_DATE","@DATE",,,"","",$FFFFFFFF
Index==0,COMM_ID
Index==0,DELIVERY_DATE
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20080302003405
Position="MAIN",1250,800

[Relation]
Entity1=TB_CUSTOMER
Entity2=TB_ORDER
RelationType1=1
RelationType2=3
Fields1=CUST_NO
Fields2=CUST_NO
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5000,5030,5000,R,R
Dependence=0
Caption=
PName=
ModifiedDateTime=20080426223018
LineMode=0
Bar1=500
Bar2=503
Bar3=500
TermPos1=R
TermPos2=R

[Entity]
PName=TB_ORDER
LName=注文
Comment=注文情報が入ります。
TableOption=
Page=MAIN
Left=1200
Top=250
Field="注文番号","ORDER_NO","*注文番号","NOT NULL",0,"","",$FFFFFFFF
Field="お客様番号","CUST_NO","*お客様番号",,,"","",$FFFFFFFF
Field="お届け先郵便番号","POSTAL_CD","@VARCHAR(7)",,,"","ハイフンは含まない",$FFFFFFFF
Field="注文日","ORDER_DT","@DATE",,,"","",$FFFFFFFF
Field="お届け先1","ADDRESS1","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="お届け先2","ADDRESS2","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="全て納品済みフラグ","DELIVERY_FLAG","@CHAR(1)",,,"","",$FFFFFFFF
Field="分納可能フラグ","SPLIT_FLAG","@CHAR(1)",,,"","",$FFFFFFFF
Index==0,CUST_NO,ORDER_DT
Index==0,ORDER_DT,CUST_NO
Index==0,DELIVERY_FLAG
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20080522014146
Position="MAIN",1200,250

[Relation]
Entity1=MS_COMMODITY
Entity2=TB_STOCK
RelationType1=2
RelationType2=3
Fields1=COMM_ID
Fields2=COMM_ID
Cardinarity1=
Cardinarity2=
Position="MAIN",0,7330,6950,5000,R,R
Dependence=1
Caption=
PName=
LineMode=0
Bar1=733
Bar2=695
Bar3=500
TermPos1=R
TermPos2=R

[Entity]
PName=TB_STOCK
LName=在庫テーブル
Comment=
TableOption=
Page=MAIN
Left=350
Top=1600
Field="商品番号","COMM_ID","*商品番号","NOT NULL",0,"","",$FFFFFFFF
Field="枝番","SUB_NO","@INT","NOT NULL",1,"","",$FFFFFFFF
Field="棚番号","RACK_NO","@VARCHAR(30)",,,"","",$FFFFFFFF
Field="在庫数量","STOCK_NUM","@INT",,,"","",$FFFFFFFF
Field="備考","NOTES","*備考",,,"","",$FFFFFFFF
EffectMode=None
Color=$000000
BkColor=$FFFFFF
Position="MAIN",350,1600

[Relation]
Entity1=MS_COMMODITY
Entity2=TB_UNITPRICE
RelationType1=2
RelationType2=1
Fields1=COMM_ID
Fields2=COMM_ID
Cardinarity1=
Cardinarity2=
Position="MAIN",0,4440,4360,5000,R,R
Dependence=1
Caption=
PName=
LineMode=0
Bar1=444
Bar2=436
Bar3=500
TermPos1=R
TermPos2=R

[Entity]
PName=TB_UNITPRICE
LName=単価テーブル
Comment=
TableOption=
Page=MAIN
Left=350
Top=1200
Field="日付","SALE_DATE","@DATE","NOT NULL",0,"","",$FFFFFFFF
Field="商品番号","COMM_ID","*商品番号","NOT NULL",1,"","",$FFFFFFFF
Field="単価","PRICE","@INT","NOT NULL",,"","",$FFFFFFFF
Index==0,COMM_ID
EffectMode=None
Color=$000000
BkColor=$FFFFFF
Position="MAIN",350,1200

[Relation]
Entity1=MS_MAKER
Entity2=MS_COMMODITY
RelationType1=2
RelationType2=3
Fields1=MAKER_CD
Fields2=MAKER_CD
Cardinarity1=
Cardinarity2=
Position="MAIN",0,5000,5000,5000,R,R
Dependence=0
Caption=
PName=
LineMode=0
Bar1=500
Bar2=500
Bar3=500
TermPos1=R
TermPos2=R

[Entity]
PName=MS_MAKER
LName=メーカーマスタ
Comment=
TableOption=
Page=MAIN
Left=2050
Top=1600
Field="メーカーコード","MAKER_CD","*メーカーコード","NOT NULL",0,"","",$FFFFFFFF
Field="メーカー名","MAKER_NM","*メーカー名",,,"","",$FFFFFFFF
Field="住所１","ADDRESS1","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="住所２","ADDRESS2","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="備考","NOTES","*備考",,,"","",$FFFFFFFF
EffectMode=None
Color=$FF0000
BkColor=$FFFFFF
Position="MAIN",2050,1600

[Entity]
PName=MS_COMMODITY
LName=商品マスタ
Comment=
TableOption=
Page=MAIN
Left=1250
Top=1250
Field="商品番号","COMM_ID","*商品番号","NOT NULL",0,"","",$FFFFFFFF
Field="商品名","COMM_NM","*商品名",,,"","",$FFFFFFFF
Field="メーカーコード","MAKER_CD","*分類ID",,,"","",$FFFFFFFF
Field="標準小売価格","PRICE","*価格",,,"","",$FFFFFFFF
Field="商品種別","COMM_TYPE","*商品種別",,,"","",$FFFFFFFF
Field="商品分類ID","CLASS_ID","*分類ID",,,"","",$FFFFFFFF
Field="備考","NOTES","*備考",,,"","",$FFFFFFFF
Index==0,CLASS_ID
EffectMode=None
Color=$FF0000
BkColor=$FFFFFF
ModifiedDateTime=20080302003415
Position="MAIN",1250,1250

[Entity]
PName=TB_CUSTOMER
LName=顧客
Comment=
TableOption=
Page=MAIN
Left=350
Top=400
Field="お客様番号","CUST_NO","*お客様番号","NOT NULL",0,"","",$FFFFFFFF
Field="名前","CUST_NM","*人名","NOT NULL",,"","",$FFFFFFFF
Field="パスワード","LOGIN_PASSWORD","@VARCHAR(40)",,,"","",$FFFFFFFF
Field="会員登録日","REGIST_DATE","@DATE",,,"","",$FFFFFFFF
Field="生年月日","BIRTHDAY","@DATE",,,"","",$FFFFFFFF
Field="郵便番号","POSTAL_CD","@VARCHAR(7)",,,"","",$FFFFFFFF
Field="住所１","ADDRESS1","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="住所２","ADDRESS2","@VARCHAR(60)",,,"","",$FFFFFFFF
Field="電話番号","TEL_NO","@VARCHAR(20)",,,"","",$FFFFFFFF
Field="メールアドレス","EMAIL","@VARCHAR(50)",,,"","",$FFFFFFFF
Field="備考","NOTES","*備考",,,"","",$FFFFFFFF
EffectMode=None
Color=$000000
BkColor=$FFFFFF
ModifiedDateTime=20080302003426
Position="MAIN",350,400
