IRUM

Tables (26)

BANNER (배너)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field11) — TEXT
  • de_text (Field12) — TEXT
  • order (Field2) — INTEGER
  • ison (Field3) — BOOLEAN
  • pcimage (Field4) — TEXT
  • link (Field9) — TEXT
  • mobileimage (Field5) — TEXT
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE
  • tabletimage (Field8) — TEXT
  • country (Field10) — TEXT

BRAND (브랜드필드)

  • Key — Primary key — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field5) — TEXT
  • de_text (Field6) — TEXT
  • thumb (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

CART (장바구니)

  • id (Key) — Primary key — NOT NULL
  • desingId (Key2) — INTEGER — Foreign key → DESIGN.id — NOT NULL

CART_NONMBBR (장바구니 비회원)

  • id (Key) — Primary key — NOT NULL
  • nonmbbrId (Key2) — INTEGER — Foreign key → NONMBBR.id — NOT NULL
  • cartId (Key3) — INTEGER — Foreign key → CART.id — NOT NULL

CART_USER (장바구니 회원)

  • id (Key) — Primary key — NOT NULL
  • userId (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
  • cartId (Key2) — INTEGER — Foreign key → CART.id — NOT NULL
  • designId (Key4) — INTEGER — Foreign key → DESIGN.id — NOT NULL

COLOR (색상프로파일)

  • id (Key) — Primary key — NOT NULL
  • en_text (Field2) — TEXT
  • kr_text (Field5) — TEXT
  • de_text (Field6) — TEXT
  • rgb (Field) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

DESIGN (디자인 필드)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field3) — TEXT
  • de_text (Field12) — TEXT
  • content (Field2) — TEXT
  • photoPosition (Field6) — JSON
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE
  • themename (Field7) — TEXT
  • brandname (Field8) — TEXT
  • category (Field11) — TEXT
  • createdAt (Field9) — DATE
  • updatedAt (Field10) — DATE

EVENT (이벤트)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field9) — TEXT
  • de_text (Field10) — TEXT
  • order (Field2) — INTEGER
  • ison (Field3) — BOOLEAN
  • image (Field4) — TEXT
  • content (Field5) — TEXT
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE
  • country (Field8) — TEXT

INQUIRY (문의)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • content (Field) — TEXT
  • iswhthr (Field2) — BOOLEAN
  • images (Field3) — JSON
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE
  • country (Field6) — TEXT

INQUIRY_CONT (문의내용)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • inquiryid (Key2) — Foreign key → INQUIRY.id — NOT NULL
  • userid (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
  • id (Key22) — INTEGER — Foreign key → INQUIRY.userid — NOT NULL
  • content (Field) — TEXT
  • images (Field2) — JSON
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE
  • country (Field5) — TEXT

LOGS (로그)

  • id (Key) — Primary key — NOT NULL
  • ip_address (Field) — TEXT
  • site_name (Field2) — TEXT
  • visit_date (Field3) — TEXT

MATERIAL (소재)

  • id (Key) — Primary key — NOT NULL
  • en_text (Field7) — TEXT
  • kr_text (Field8) — TEXT
  • de_text (Field9) — TEXT
  • image (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE
  • price (Field5) — INTEGER
  • sale (Field6) — INTEGER

MODEL (모델)

  • id (Key2) — Primary key — NOT NULL
  • en_text (Field4) — TEXT
  • kr_text (Field) — TEXT
  • de_text (Field6) — TEXT
  • type (Field5) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

MODEL_COLOR (디자인/컬러간필드)

  • id (Key2) — Primary key — NOT NULL
  • colorId (Key) — Foreign key → COLOR.id — NOT NULL
  • designid (Key3) — INTEGER — Foreign key → DESIGN.id — NOT NULL
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

MODEL_MATERIAL (모델/소재간 필드)

  • id (Key2) — Primary key — NOT NULL
  • materialId (Key) — Foreign key → MATERIAL.id — NOT NULL
  • modelid (Key22) — Foreign key → MODEL.id — NOT NULL
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

MODEL_PRODUCT (모델/디자인간 상품필드)

  • id (Key2) — Primary key — NOT NULL
  • modelid (Key22) — Foreign key → MODEL.id — NOT NULL
  • designid (Key) — INTEGER — Foreign key → DESIGN.id — NOT NULL
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

MODEL_STICKER (모델/스티커간 상품필드)

  • id (Key2) — INTEGER — Primary key — NOT NULL
  • desingid (Key) — INTEGER — Foreign key → DESIGN.id — NOT NULL
  • stickerid (Key3) — INTEGER — Foreign key → STIKCER.id — NOT NULL
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

NONMBBR (비회원)

  • id (Key) — Primary key — NOT NULL
  • order_name (Field) — TEXT
  • order_email (Field2) — TEXT
  • uuid (Field4) — TEXT
  • country (Field3) — TEXT

NOTICE (공지사항)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field9) — TEXT
  • de_text (Field10) — TEXT
  • order (Field2) — INTEGER
  • ison (Field3) — BOOLEAN
  • images (Field4) — TEXT
  • content (Field5) — TEXT
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE
  • country (Field8) — TEXT

PAY_NONMBBR (결제_비회원)

  • id (Key) — Primary key — NOT NULL
  • nonmbbrId (Key2) — INTEGER — Foreign key → NONMBBR.id — NOT NULL
  • userId (Key3) — INTEGER — Foreign key → USER_ORDER.id — NOT NULL

PAY_USER (결제_회원)

  • id (Key) — Primary key — NOT NULL
  • userId (Key2) — 회원아이디 — Foreign key → USER.id — NOT NULL
  • orderId (Key3) — INTEGER — Foreign key → USER_ORDER.id — NOT NULL

STICKER_CATEGORY (스티커카테고리명)

  • id (Key) — Primary key — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field2) — TEXT
  • de_text (Field3) — TEXT

STIKCER (스티커 필드)

  • id (Key) — Primary key — NOT NULL
  • en_text (Field5) — TEXT
  • kr_text (Field6) — TEXT
  • de_text (Field7) — TEXT
  • image (Field) — TEXT
  • stkcategory (Field4) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

THEME (테마필드)

  • Key — Primary key — NOT NULL
  • en_text (Field) — TEXT
  • kr_text (Field5) — TEXT
  • de_text (Field6) — TEXT
  • thumb (Field2) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

USER (회원)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • join (Field) — STRING
  • email (Field2) — STRING
  • password (Field3) — STRING
  • salt (Field4) — STRING
  • tel (Field5) — STRING
  • accept (Field6) — JSON
  • name (Field12) — TEXT
  • level (Field7) — INTEGER
  • access (Field8) — INTEGER
  • logincount (Field9) — INTEGER
  • createdAt (Field10) — DATE
  • updatedAt (Field11) — DATE
  • country (Field13) — TEXT

USER_ORDER (주문)

  • id (Key) — Primary key — NOT NULL
  • pg (Field) — TEXT
  • pay_method (Field2) — TEXT
  • name (Field3) — TEXT
  • merchant_uid (Field4) — TEXT
  • amount (Field5) — TEXT
  • digital (Field6) — BOOlEAN
  • app_scheme (Field7) — TEXT
  • buyer_name (Field8) — TEXT
  • buyer_email (Field9) — TEXT
  • buyer_addr (Field10) — TEXT
  • buyer_postcode (Field11) — TEXT
  • buyer_tel (Field12) — TEXT
  • pay_mode (Field13) — TEXT
  • pay_type (Field14) — TEXT
  • count (Field15) — TEXT
  • country (Field16) — TEXT