지원사업 검색기 ERD
테이블 (5)
Biz (k-startup)
- id (Key) — num — 기본 키 — NOT NULL
- postsn (Field) — text
- title (Field2) — text
- supporttype (Field3) — text
- areaname (Field4) — text
- organizationname (Field5) — text
- posttarget (Field6) — text
- minage (Field7) — num
- maxage (Field8) — num
- comage (Field9) — num
- startdate (Field10) — date
- enddate (Field11) — data
- insertdate (Field12) — data
- detailurl (Field13) — text
User (Untitled)
- Key — num — 기본 키 — NOT NULL
- email (Field) — text
- birthDay (Field2) — date
- name (Field3) — text
- isFounded (Field4) — yes|no
- combirth (Field5) — date
- like_sup_type1 (Field6) — text
- like_sup_type2 (Field7) — text
Wait Biz (Untitled2)
- Key — 기본 키 — NOT NULL
- Mother_id (Key2) — num — 외래 키 → bubble.io Mother DB.id — NOT NULL
- User_Key (Key3) — num — 외래 키 → User.Key — NOT NULL
Yse Biz (Untitled3)
- Key — 기본 키 — NOT NULL
- User_Key (Key2) — num — 외래 키 → User.Key — NOT NULL
- Mother_id (Key3) — num — 외래 키 → bubble.io Mother DB.id — NOT NULL
- status (Field) — text
- Result (Field2) — text
bubble.io Mother DB (CopyOfk-startup)
- id (Key) — num — 기본 키 — NOT NULL
- postsn (Field) — text
- title (Field2) — text
- supporttype (Field3) — text
- areaname (Field4) — text
- organizationname (Field5) — text
- posttarget (Field6) — text
- minage (Field7) — num
- maxage (Field8) — num
- comage (Field9) — num
- startdate (Field10) — date
- enddate (Field11) — data
- insertdate (Field12) — data
- detailurl (Field13) — text