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