KONEST_App_Backend_ERD
Tables (15)
address
- id — SERIAL — Primary key
- road_address — VARCHAR(200)
- lot_address — VARCHAR(200)
- lat — DOUBLE
- lng — DOUBLE
- sub_area_id — SERIAL — Foreign key → sub_area.id
app_user
- id — SERIAL — Primary key
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50)
- created_at — TIMESTAMP
area
- id — SERIAL — Primary key
- name_kr — VARCHAR(100) — NOT NULL
- name_jp — VARCHAR(100)
- name_cn — VARCHAR(100)
bus_line
- id — SERIAL — Primary key
- name — VARCHAR(100)
- direction — VARCHAR(50)
bus_line_stop
- id — SERIAL — Primary key
- stop_order — INT
- bus_line_id — SERIAL — Foreign key → bus_line.id
- bus_stop_id — SERIAL — Foreign key → bus_stop.id
bus_stop
- id — SERIAL — Primary key
- name — VARCHAR(100)
- lat — DOUBLE
- lng — DOUBLE
poi
- id — SERIAL — Primary key
- name — VARCHAR(100)
- address_id — INT
- lat — DOUBLE
- lng — DOUBLE
- description — TEXT
- category_id — INT
poi_tag_map
- id — SERIAL — Primary key
- poi_id — INT
- tag_id — INT
sub_area
- id — SERIAL — Primary key
- name_kr — VARCHAR(100) — NOT NULL
- name_jp — VARCHAR(100)
- name_cn — VARCHAR(100)
- area_id — SERIAL — Foreign key → area.id
subway_line
- id — SERIAL — Primary key
- name — VARCHAR(100)
- color_code — VARCHAR(10)
subway_station
- id — SERIAL — Primary key
- name — VARCHAR(100)
- lat — DOUBLE
- lng — DOUBLE
- subway_line_id — SERIAL — Foreign key → subway_line.id
tag
- id — SERIAL — Primary key
- name — VARCHAR(50)
user_favorite_poi
- id — SERIAL — Primary key
- poi_id — INT — NOT NULL
- created_at — TIMESTAMP
- app_user_id — INT — Foreign key → app_user.id
- app_favorite_folder_id — INT — Foreign key
weather_icon
- id — SERIAL — Primary key
- icon_code — INT — NOT NULL
- description_kr — VARCHAR(100)
- description_jp — VARCHAR(100)
- description_cn — VARCHAR(100)
weather_info
- id — SERIAL — Primary key
- area_code — VARCHAR(20)
- temperature — FLOAT
- icon_code — INT
- description_kr — VARCHAR(50)
- description_jp — VARCHAR(50)
- description_cn — VARCHAR(50)
- updated_at — TIMESTAMP
- address_id — SERIAL — Foreign key → address.id
- weather_icon_id — SERIAL — Foreign key → weather_icon.id