test
Tables (9)
available_time
- seq — int — Primary key — NOT NULL
- clinic_id — varchar(25) — Primary key — NOT NULL
- time — varchar(45)
clinic
- id — varchar(25) — Primary key — NOT NULL
- name — varchar(45)
- password — varchar(45)
- latitude — double
- longitude — double
- start_time — varchar(45)
- end_time — varchar(45)
- introduction — varchar(150)
- address — varchar(100)
- phone — varchar(20)
- image — varchar(150)
favorite
- seq — int — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- clinic_id — varchar(25) — Primary key — NOT NULL
- name — varchar(45)
- password — varchar(45)
- latitude — double
- longitude — double
- start_time — varchar(45)
- end_time — varchar(45)
- introduction — varchar(150)
- address — varchar(100)
- phone — varchar(20)
- image — varchar(1000)
pet
- user_id — varchar(20) — Primary key — NOT NULL
- species_type — varchar(45) — Primary key — NOT NULL
- species_category — varchar(45) — Primary key — NOT NULL
- id — varchar(45) — Primary key — NOT NULL
- name — varchar(45)
- birthday — varchar(45)
- features — varchar(45)
- gender — varchar(45)
- image — varchar(1000)
reservation
- seq — int — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- clinic_id — varchar(25) — Primary key — NOT NULL
- time — varchar(45)
- symptoms — varchar(150)
species
- type — varchar(45) — Primary key — NOT NULL
- category — varchar(45) — Primary key — NOT NULL
treatment
- id — int — Primary key — NOT NULL
- user_id — varchar(20) — Primary key — NOT NULL
- clinic_id — varchar(25) — Primary key — NOT NULL
- content — varchar(150)
treatmentable
- id — int — Primary key — NOT NULL
- clinic_id — varchar(25) — Primary key — NOT NULL
- name — varchar(45)
- price — int
- content — varchar(45)
user
- id — varchar(20) — Primary key — NOT NULL
- password — varchar(45)
- image — varchar(1000)
- name — varchar(45)
- phone — varchar(13)