models
Tables (8)
Agency
- id — INT
- name — VARCHAR(200)
- address — VARCHAR(200)
- phone — VARCHAR(50)
- scope — VARCHAR(200)
Certification (GAP 인증)
- id — INT
- cert_number — VARCHAR(100)
- cert_start — DATE
- cert_end — DATE
- valid — BOOLEAN
- farm_id — INT
- agency_id — INT
City (시군구)
- id — INT
- name — VARCHAR(100)
- region_id — INT
Farm (농가)
- id — INT
- name — VARCHAR(100)
- owner — VARCHAR(100)
- address — VARCHAR(200)
- town_id — INT
- land_area — FLOAT
- production — FLOAT
Farm_Item (농가 품목)
- farm_id — INT
- item_id — INT
Item (품목)
- id — INT
- name — VARCHAR(100)
Region (시도)
- id — INT
- name — VARCHAR(100)
- area — FLOAT
Town (읍면동)
- id — INT
- name — VARCHAR(100)
- city_id — INT