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