BizLink

Tables (33)

Brand (브랜드)

  • title (Field) — TEXT
  • icon (Field2) — TEXT
  • Thumicon (Field3) — TEXT
  • open (Field4) — BOOLEAN
  • infoimages (Field5) — JSON
  • seller (Field9) — INTEGER
  • viewer (Field8) — INTEGER
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE

Comment (댓글)

  • id (Key) — Primary key — NOT NULL
  • Feedid (Key3) — INTEGER — Foreign key → FEED.id — NOT NULL
  • content (Field)
  • isShow (Field2) — BOOLEAN

Event (CopyOf공지사항)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — TEXT
  • thumb (Field6) — TEXT
  • content (Field2) — TEXT
  • contry (Field3) — TEXT
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE
  • isOpen (Field7) — BOOLEAN

FEED (피드)

  • id (Key) — Primary key — NOT NULL
  • content (Field) — TEXT
  • images (Field2) — JSON
  • likeCount (Field3) — INTEGER
  • country (Field4) — TEXT
  • createdAt (Field5)
  • updatedAt (Field6)

IRDATA (IR)

  • id (Key) — Primary key — NOT NULL
  • IR날짜 (Field3)
  • 보조자료 (Field7)
  • 제보방식 (Field8)
  • IR라운드 (Field)
  • IR목표금액 (Field2)
  • 회사프로필 (Field4)
  • 회사명 (Field5)
  • 회사상장여부 (Field6)
  • 주요 투자자 정보 (Field9)

MemberShip (정부지원과제)

  • id (Key) — Primary key — NOT NULL
  • postsn (Field) — INTEGER
  • title (Field2) — STRING
  • supporttype (Field3) — STRING
  • biztitle (Field4) — STRING
  • arename (Field5) — STRING
  • organizationname (Field6) — STRING
  • posttarget (Field7) — STRING
  • startdate (Field8) — STRING
  • enddate (Field9) — DATE
  • insertdate (Field10) — DATE
  • viewcount (Field11) — INTEGER
  • detailurl (Field12) — STRING

Notice (공지사항)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — TEXT
  • content (Field2) — TEXT
  • contry (Field3) — TEXT
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

OFFICE (업체)

  • id (Key) — Primary key — NOT NULL
  • name (Field) — STRING
  • 산업분류명칭 (Field2) — STRING
  • 산업분류코드 (Field23) — STRING
  • zip (Field3) — JSON
  • page (Field4) — STRING
  • view (Field5) — INTEGER
  • latitude (Field6) — FLOAT
  • longitude (Field7) — FLOAT
  • images (Field8) — JSON
  • tel (Field11) — TEXT
  • info (Field12) — TEXT
  • createdAt (Field9) — DATE
  • updatedAt (Field10) — DATE
  • isName (Field13) — BOOLEAN
  • isZip (Field14) — BOOLEAN
  • isHome (Field15) — BOOLEAN
  • isTel (Field16) — BOOLEAN
  • isCategory (Field17) — BOOLEAN
  • isInfo (Field18) — BOOLEAN
  • isBadge (Field19) — BOOLEAN
  • badge (Field20) — BOOLEAN
  • createdAt (Field21) — DATE
  • updatedAt (Field22) — DATE

RCDATA (투자자)

  • id (Key) — Primary key — NOT NULL
  • 회사명 (Field)
  • 회사프로필 (Field2)
  • 회사상장여부 (Field3)
  • 분류 (Field4)
  • 최근투자날짜 (Field5)
  • 총 투자 집행금액 (Field6)

RecFriend (추천친구)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — Foreign key → user_order.id — NOT NULL
  • tragetid (Field)

Recomment (대댓글)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • cmtId (Key3) — INTEGER — Foreign key → Comment.id — NOT NULL
  • userid (Key22) — INTEGER — Foreign key — NOT NULL
  • content (Key2) — TEXT

STARTUP (스타트업)

  • id (Key) — Primary key — NOT NULL
  • 회사명 (Field)
  • 회사프로필 (Field2)
  • 회사상장여부 (Field3)
  • 제품서비스이미지 (Field4)
  • 제품서비스명 (Field5)
  • 제품서비스설명 (Field6)

USER (회원)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • OfficeId (Key2) — Foreign key → OFFICE.id — NOT NULL
  • email (Field) — STRING
  • name (Field2) — STRING
  • nickname (Field3) — STRING
  • password (Field4) — STRING
  • salt (Field5) — STRING
  • birth (Field6) — DATE
  • badge (Field7) — BOOLEAN
  • fcm (Field10) — STRING
  • createdAt (Field8) — DATE
  • updatedAt (Field9) — DATE
  • category (Field11) — STRING
  • subcategory (Field12) — STRING
  • tel (Field13) — JSON
  • logeedin (Field14) — INTEGER
  • isAlert (Field15) — BOOLEAN
  • isKeyword (Field16) — BOOLEAN

USER_RECATE (관심카테고리)

  • id (Key2) — Primary key — NOT NULL
  • userid (Key) — INTEGER — Foreign key → USER.id — NOT NULL
  • id (Key22) — Foreign key → USER.OfficeId — NOT NULL
  • 행사네트워크 (Field2) — BOOLEAN
  • 창업고육 (Field3) — BOOLEAN
  • 멘토링컨설팅 (Field4) — BOOLEAN
  • 사업화 (Field5) — BOOLEAN
  • 판로해외진출 (Field) — BOOLEAN
  • 정책자금 (Field6) — BOOLEAN
  • 연구개발 (Field7) — BOOLEAN
  • 시설공간보육 (Field8) — BOOLEAN
  • 융자 (Field9) — BOOLEAN

Untitled3

    VCDATA (투자)

    • id (Key) — Primary key — NOT NULL
    • 투자날짜 (Field) — STRING
    • 보조자료 (Field2) — STRING
    • 제보방식 (Field3) — STRING
    • 투자단계 (Field4) — STRTING
    • 정확도 (Field5) — STRING
    • 투자대상프로필 (Field6) — JSON
    • 투자대상회사명 (Field7) — STRING
    • 투자대상상장여부 (Field8) — STRING
    • 투자자정보 (Field9) — JSON

    banner (기업 배너)

    • id (Key) — Primary key — NOT NULL
    • title (Field) — TEXT
    • mode (Field7) — TEXT
    • image (Field2) — TEXT
    • viewtype (Field3) — TEX
    • startDate (Field4) — TEXT
    • endDate (Field5) — TEXT
    • createdAt (Field6) — DATE
    • view (Field8) — INTEGER
    • cpc (Field9) — INTEGER

    feed_del (피드 신고내역)

    • id (Key) — Primary key — NOT NULL
    • FeedId (Key2) — INTEGER — Foreign key → FEED.id — NOT NULL
    • content (Field) — STRING

    indst (산업분류 카테고리)

    • id (Key) — Primary key — NOT NULL
    • 산업분류명칭 (Field) — STRING
    • 산업분류코드 (Field2) — STRING

    product (상품)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • userid (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
    • id (Key2) — Foreign key → USER.OfficeId — NOT NULL
    • title (Field) — STRING
    • content (Field3) — TEXT
    • images (Field2) — JSON
    • infoimages (Field9) — JSON
    • likepoint (Field10) — INTEGER
    • view (Field4) — INTEGER
    • paid (Field5) — INTEGER
    • price (Field6) — INTEGER
    • createdAt (Field7) — DATE
    • updatedAt (Field8) — DATE
    • category (Field11) — TEXT
    • subCategory (Field12) — TEXT

    product_category (Untitled)

    • id (Key) — STRING — Primary key — NOT NULL
    • title (Field) — STRING
    • icon (Field2) — STRING
    • createdAt (Field3) — DATE
    • updatedAt (Field4) — DATE

    product_subcategory (서브 카테고리)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • product_categoryid (Key2) — INTEGER — Foreign key → product_category.id — NOT NULL
    • title (Field) — STRING
    • createdAt (Field2) — DATE
    • updatedAt (Field3) — DATE

    road (시군구 데이터)

    • Key — Primary key — NOT NULL
    • 행정구역명 (Field) — TEXT

    user_alert (알림)

    • id (Key) — Primary key — NOT NULL
    • title (Field) — STRING
    • content (Field2) — STRING
    • detailNav (Field3) — TEXT
    • Field4

    user_chat (Untitled2)

    • Key — Primary key — NOT NULL
    • id (Key2) — Foreign key → OFFICE.id — NOT NULL
    • Field
    • Field2
    • Field3

    user_keyword (회원 알림키워드)

    • id (Key) — INTEGER — Primary key — NOT NULL
    • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
    • id (Key22) — Foreign key → USER.OfficeId — NOT NULL
    • keyword (Field)

    user_like (찜한상품)

    • userid (Key) — INTEGER — Foreign key → USER.id — NOT NULL
    • productid (Key2) — INTEGER — Foreign key → product.id — NOT NULL
    • id (Key22) — Foreign key → USER.OfficeId — NOT NULL

    user_likecmt (댓글 좋아요)

    • cmtId (Key) — INTEGER — Foreign key → Comment.id — NOT NULL

    user_likefeed (피드 좋아요)

    • Feedid (Key) — INTEGER — Foreign key → FEED.id — NOT NULL

    user_likerecmt (대댓글 좋아요)

    • recmtId (Key3) — INTEGER — Foreign key → Recomment.cmtId — NOT NULL

    user_logedin (로그인 위치)

    • Key2 — Primary key — NOT NULL
    • userid (Key) — INTEGER — Foreign key → USER.id — NOT NULL
    • id (Key22) — Foreign key → USER.OfficeId — NOT NULL
    • title (Field) — STRING
    • used (Field2) — BOOLEAN
    • zip (Field3) — JSON
    • latitude (Field4) — FLOAT
    • longitude (Field5) — FLOAT
    • createdAt (Field6) — DATE
    • updatedAt (Field7) — DATE

    user_order (요청서)

    • id (Key) — Primary key — NOT NULL
    • type (Field) — STRING
    • image (Field2) — STRING
    • title (Field3) — STRING
    • category (Field4) — STRING
    • subCategory (Field5) — STRING
    • info (Field6) — TEXT
    • infoimages (Field7) — JSON
    • order (Field8) — STRING
    • zip (Field9) — JSON
    • createdAt (Field10) — DATE
    • updatedAt (Field11) — DATE

    verify_user (회원인증)

    • id (Key4) — Primary key — NOT NULL
    • userid (Key2) — Foreign key → USER.OfficeId — NOT NULL
    • officeid (Key3) — Foreign key → OFFICE.id — NOT NULL
    • name (Field) — STRING
    • position (Field3)
    • duty (Field4)
    • face (Field5)
    • file (Field6)
    • fileName (Field7)
    • mime (Field8)
    • docstype (Field9)
    • isAccess (Field10)