jaranara
Tables (6)
admin (Untitled)
- admin_id (Key) — varchar2(20) — Primary key — NOT NULL
- pw (Field) — number
area (Untitled2)
- area_id (Key) — number — Primary key — NOT NULL
- area_name (Field) — varchar2(100) — NOT NULL
heatmap (Untitled6)
- loc_num (Key) — varchar2(200) — Primary key — NOT NULL
- loc_location (Field) — varchar2(200)
- score (Field2) — varchar2(90)
- position (Field3) — varchar2(200)
school (Untitled3)
- school_location (Key) — varchar2(50) — Primary key — NOT NULL
- area_id (Key2) — number — Foreign key → area.area_id — NOT NULL
- school_name (Field) — varchar2(50)
- playgrounds (Field3) — number
upload (Untitled5)
- upload_num (Key) — number — Primary key — NOT NULL
- user_tel (Key2) — varchar2(50) — Foreign key → user.user_tel — NOT NULL
- school_location (Key3) — varchar2(50) — Foreign key → school.school_location — NOT NULL
- admin_id (Key5) — varchar2(20) — Foreign key → admin.admin_id — NOT NULL
- loc_num (Key4) — varchar2(200) — Foreign key → heatmap.loc_num — NOT NULL
- upload_date (Field2) — date
- upload_filename (Field4) — varchar2(100)
- upload_remarks (Field5) — varchar2(1024)
user (Untitled4)
- user_tel (Key) — varchar2(50) — Primary key — NOT NULL
- user_name (Field) — varchar2(40)