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)