지원사업 검색기 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