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)