<aside> ⏰ https://app.quickdatabasediagrams.com/#/d/SVcGqV

</aside>

# Modify this code to update the DB schema diagram.
# To reset the sample schema, replace everything with
# two dots ('..' - without quotes).

institution
-
ins_num PK smallint 
ins_address_index FK >- ins_address.address_index
ins_name UNIQUE string

ins_capacity
-
ins_num PK smallint FK >- institution.ins_num 
caring_bed_num smallint
nursing_bed_num smallint
dementia_bed_num smallint
empty_bed_num smallint #derived
longterm_caring_bed_num smallint
housing_bed_num smallint #derived
providing_bed_num smallint

ins_info
-
ins_num PK smallint FK >- institution.ins_num
chairman varchar(28)
phone string
email string
website string

ins_address
-
address_index smallint
address string
city char(6)
dist varchar(15)
longitude float
latitude float

TYPE_FUNCTION
-
int_num PK smallint FK >- institution.ins_num
type smallchar
func_name varchar(60)

機構Object：

功能Function：

條件Condition：