IMI

Tables (32)

Jobs (직업)

  • id (PK) — Primary key — NOT NULL
  • title (Field) — STRING
  • order (Field4) — INTEGER
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

banner (배너)

  • id (PK) — VARCHAR — Primary key — NOT NULL
  • images (Field) — JSON
  • order (Field2) — INTEGER
  • link (Field5) — STRING
  • position (Field6) — STRING
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

casting (클라이언트 매니지먼트 캐스팅)

  • id (고유키) — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • images (Field16) — JSON
  • type (Field) — INTEGER
  • title (Field2) — STRING
  • curfed (Field4) — STRING
  • fedmem (Field3) — INTEGER
  • sex (Field5) — STRING
  • age (Field6) — STRING
  • ageOpen (Field7) — BOOLEAN
  • startDate (Field8) — DATE
  • endDate (Field9) — DATE
  • startODate (Field10) — DATE
  • endODate (Field11) — DATE
  • sendType (Field12) — STRING
  • tag (Field13) — JSON
  • content (Field14) — STRING
  • faq (Field15) — STRING
  • dateOpen (Field17) — BOOLEAN

casting_order (Untitled)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → casting.userid — NOT NULL
  • poostid (PK2) — INTEGER — Foreign key → post.id — NOT NULL
  • name (Field) — STRING
  • email (Field2) — STRING
  • tel (Field3) — STRING

categorys (임플루언서 카테고리)

  • id (PK) — Primary key — NOT NULL
  • title (Field) — STRING
  • order (Field4) — INTEGER
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

coupon (쿠폰)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • code (Field) — STRING
  • issued (Field5) — BOOLEAN
  • start (Field4) — DATE
  • end (Field6) — DATE
  • updatedAt (Field2) — DATE
  • createdAt (Field3) — DATE

itemCategory (품목별 카테고리)

  • id (Key) — Primary key — NOT NULL
  • title (Field) — STRING
  • order (Field4) — INTEGER
  • image (Field5) — JSON
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

marketCategory (마켓별 카테고리)

  • id (Key) — Primary key — NOT NULL
  • title (Field) — STRING
  • order (Field4) — INTEGER
  • image (Field5) — JSON
  • createedAT (Field2) — DATE
  • updatedAt (Field3) — DATE

marketqa (상점문의)

  • id (Key) — INTGER — Primary key — NOT NULL
  • marketid (외래키(상점)) — INTGER — Foreign key → user_market.id — NOT NULL
  • productid (외래키(상품아이디)) — INTEGER — Foreign key → product.id — NOT NULL
  • userid (문의자) — INTEGER — Foreign key → user.id — NOT NULL
  • id (PK2) — INTGER — Foreign key → product.marketid — NOT NULL
  • title (Filed) — STRING
  • content (Filed2) — STRING
  • encer (Filed3) — STRING
  • encertype (Filed4) — BOOLEAN

notice (공지사항)

  • id (PK) — Primary key — NOT NULL
  • title (Field5) — STRING
  • content (Field3) — TEXT
  • images (Field4) — JSON
  • createdAt (Field) — DATE
  • updatedAt (Field2) — DATE

option (옵션)

  • id (PK) — Primary key — NOT NULL
  • optionid (FK) — Foreign key → option_category.id — NOT NULL
  • id (PK2) — INTGER — Foreign key → option_category.id — NOT NULL
  • title (Field) — STRING
  • count (Field2) — INTGER
  • price (Field3) — INTEGER
  • updatedAt (Field4) — DATE
  • createdAt (Field5) — DATE

option_category (옵션카테고리)

  • id (PK) — Primary key — NOT NULL
  • productid (FK) — Foreign key → product.id — NOT NULL
  • id (PK2) — INTGER — Foreign key → product.marketid — NOT NULL
  • title (Field) — STRING

post (게시글[포트폴리오])

  • id (PK) — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • postCategoryid (Key) — STRING — Foreign key → postCategory.id — NOT NULL
  • images (Field) — JSON
  • content (Field3) — TEXT
  • view (Field6) — INTEGER
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

postCategory (포트폴리오 카테고리)

  • id (Key) — Primary key — NOT NULL
  • title (Field) — STRING
  • order (Field4) — INTEGER
  • image (Field5) — JSON
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

product (상품)

  • id (PK) — Primary key — NOT NULL
  • itemCategoryid (FK2) — Foreign key → itemCategory.id — NOT NULL
  • marketid (FK3) — INTGER — Foreign key → user_market.id — NOT NULL
  • title (Field) — STRING
  • info (Field2) — STRING
  • infofull (Field7) — STRING
  • marketprice (Field8) — INTEGER
  • price (Field3) — INTEGER
  • images (Field4) — JSON
  • updatedAt (Field5) — DATE
  • createdAt (Field6) — DATE

push_logs (푸시 로그)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • title (Field) — STRING
  • content (Field2) — STRING
  • updatedAt (Field3) — DATE
  • createdAt (Field4) — DATE

sponsored (협찬)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • userid (fk) — INTEGER — Foreign key → user.id — NOT NULL
  • title (Field) — STRING
  • price (Field2) — INTEGR
  • images (Field3) — JSON
  • info (Field4) — STRING
  • infofull (Field5) — STRING
  • orderIf (Field6) — STRING
  • ordercontent (Field7) — STRING
  • orderTel (Field8) — STRING

terms (이용약관 테이블)

  • id (PK) — Primary key — NOT NULL
  • title (Field) — STRING
  • content (Field2) — TEXT
  • order (Field3) — INTEGER
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

user (회원테이블)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • categoryId (FK) — Foreign key → categorys.id — NOT NULL
  • email (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • slat (Field14) — STRING
  • salt (Field12) — STRING
  • point (Field13) — INTEGER
  • nickname (Field5) — STRING
  • info (Field7) — STRING
  • task (Field15) — STRING
  • order (Field8) — INTEGER
  • gm (Field9) — INTEGER
  • avatar (Field6) — JSON
  • marketmode (Field10) — BOOLEAN
  • fcm (Field11) — STRING
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE
  • wallet (Field16) — STRING

user_bookmark (북마크 게시물)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

user_cart (장바구니)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • productid (FK) — INTEGER — Foreign key → product.id — NOT NULL
  • userid (FK2) — INTEGER — Foreign key → user.id — NOT NULL
  • count (Field) — INTEGER

user_cart_option (선택옵션)

  • id (PK) — Primary key — NOT NULL
  • cartid (FK) — INTEGER — Foreign key → user_cart.id — NOT NULL
  • optionid (FK2) — INTEGER — Foreign key → option.optionid — NOT NULL

user_coupon (유저쿠폰)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • couponid (Key) — INTEGER — Foreign key → coupon.id — NOT NULL
  • userid (PK2) — INTEGER — Foreign key → user.id — NOT NULL
  • info (Field) — STRING
  • usestatus (Field2) — BOOLEAN
  • updatedAt (Field5) — DATE
  • createdAt (Field6) — DATE

user_follow (팔로우테이블)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • id (followerid) — INTEGER — Foreign key → user.id — NOT NULL
  • id (followingid) — INTEGER — Foreign key → user.categoryId — NOT NULL
  • Field

user_jobs (직업 연결테이블)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • jobsid (PK2) — Foreign key → Jobs.id — NOT NULL
  • userid (PK3) — INTEGER — Foreign key → user.id — NOT NULL

user_likepost (좋아요한 게시글)

  • id (PK) — INTEGER — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • postid (FK2) — Foreign key → post.id — NOT NULL
  • title (Field) — STRING
  • content (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

user_market (유저 상점 정보)

  • id (PK) — INTGER — Primary key — NOT NULL
  • userid (외래키) — INTEGER — Foreign key → user.id — NOT NULL
  • marketCategoryid (Key) — Foreign key → marketCategory.id — NOT NULL
  • marketid (Field) — STRING
  • name (Field2) — STRING
  • tel (Field3) — STRING
  • ordertel (Field4) — STRING
  • instar (Field7) — STRING
  • channel (Field8) — STRING
  • enter (Field10) — STRING
  • entercode (Field11) — STRING
  • itemofferedsale (Field13) — STRING
  • barnd (Field14) — STRING
  • receivezip (Field15) — STRING
  • bank (Field16) — STRING
  • account (Field17) — STRING
  • accountname (Field18) — STRING
  • type (Field12) — INTEGER
  • acct (Field9) — BOOLEAN
  • order (Field19) — INTEGER
  • updatedAt (Field5) — DATE
  • createdAt (Field6) — DATE

user_order (결제)

  • id (PK) — VARCHAR — Primary key — NOT NULL
  • iamcode (Field) — STRING
  • cash (Field3) — INTEGER
  • sales (Field2) — INTEGER
  • count (Field4) — INTEGER
  • price (Field5) — INTEGER
  • updatedAt (Field6) — DATE
  • createdAT (Field7) — DATE

user_order_product (주문상품리스트)

  • id (PK) — Primary key — NOT NULL
  • user_orderid (FK) — VARCHAR — Foreign key → user_order.id — NOT NULL
  • productid (PK2) — Foreign key → product.id — NOT NULL
  • id (PK22) — INTGER — Foreign key → product.marketid — NOT NULL

user_orderer (주문자정보)

  • id (PK) — Primary key — NOT NULL
  • user_orderid (FK) — VARCHAR — Foreign key → user_order.id — NOT NULL
  • name (Field) — VARCHAR
  • tel (Field2) — INTEGER
  • zip (Field3) — VARCHAR
  • zipinfo (Field4) — VARCHAR
  • email (Field5) — VARCHAR
  • updatedAt (Field6) — DATE
  • createdAt (Field7) — DATE

user_shippingInfo (배송정보)

  • id (PK) — Primary key — NOT NULL
  • user_orderid (FK) — VARCHAR — Foreign key → user_order.id — NOT NULL
  • name (Field) — VARCHAR
  • tel (Field2) — VARCHAR
  • zipname (Field4) — VARCHAR
  • zip (Field3) — VARCHAR
  • zipinfo (Field5) — VARCHAR
  • memo (Field6) — VARCHAR
  • updatedAt (Field7) — DATE
  • createdAT (Field8) — DATE

user_sns (소셜)

  • id (PK) — Primary key — NOT NULL
  • userid (FK) — INTEGER — Foreign key → user.id — NOT NULL
  • facebook (Field) — TEXT
  • instar (Field2) — TEXT
  • twitter (Field3) — TEXT
  • youtube (Field4) — TEXT
  • vimeo (Field5) — TEXT
  • sc (Field6) — TEXT
  • home (Field7) — TEXT
  • updatedAt (Field8) — DATE
  • createdAt (Field9) — DATE