GiftStar

Tables (18)

ACCOUNT (계좌정보)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • actname (Field) — TEXT
  • bank (Field2) — TEXT
  • number (Field3) — TEXT
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

BRAND (브랜드)

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

CART (장바구니)

  • id (Key) — STRING — Primary key — NOT NULL
  • userid (Key2) — STRING — Foreign key → USER.id — NOT NULL
  • productid (Key3) — STRING — Foreign key → PRODUCT.id — NOT NULL
  • product_conid (Key4) — INTEGER — Foreign key → PRODUCT_CON.productId — NOT NULL

Category (카테고리)

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

EVENT (이벤트)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — STRING — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • order (Field2) — INTEGER
  • open (Field7) — BOOLEAN
  • content (Field5) — TEXT
  • images (Field6) — STRING
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

FAQ (FAQ관리)

  • id (Key) — INTGER — Primary key — NOT NULL
  • userid (Key2) — STRING — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • order (Field2) — INTEGER
  • open (Field3) — BOOLEAN
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

INQUIRY (문의)

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

INQUIRY_ECNER (문의 답변)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • inquiryId (Key3) — INTEGER — Foreign key → INQUIRY.id — NOT NULL
  • content (Field) — TEXT
  • images (Field7) — JSON
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

NOTICE (공지사항)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userid (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — STRING
  • order (Field2) — INTEGER
  • open (Field7) — BOOLEAN
  • images (Field6) — STRING
  • content (Field5) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

POLICY (약관 및 정책)

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

PRODUCT (상품)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • brandid (Key2) — INTEGER — Foreign key → BRAND.id — NOT NULL
  • images (Field5) — STRING
  • title (Field) — STRING
  • price (Field2) — INTEGER
  • memo (Field3) — STRING
  • isuse (Field4) — BOOLEAN
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE

PRODUCT_CON (기프티콘 리스트)

  • id (고유키) — Primary key — NOT NULL
  • productId (Key) — INTEGER — Foreign key → PRODUCT.id — NOT NULL
  • image (Field) — STRING
  • count (Field2) — INTEGER
  • price (Field3) — INTGER
  • memo (Field4) — STRING
  • isuse (Field5) — BOOLEAN
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE

USER (회원(완료))

  • id (Key) — STRING — Primary key — NOT NULL
  • type (Field12) — STRING
  • email (Field8) — STRING
  • password (Field) — STRING
  • name (Field14) — STRING
  • cash (Field15) — STRING
  • salt (Field2) — STRING
  • tel (Field3) — STRING
  • accept (Field6) — BOOLEAN
  • birth (Field10) — STRING
  • gm (Field7) — INTEGER
  • price (Field11) — INTEGER
  • access (Field13) — BOOLEAN
  • Logeed (Field9) — INTEGER
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

USER_ALERT (회원알림)

  • id (Key) — STRING — Foreign key → USER.id — NOT NULL
  • type (Field) — 알림분류
  • title (Field2) — 알림제목
  • content (Field3) — 알림내용
  • createdAt (Field4) — 생성일
  • updatedAt (Field5) — 수정일
  • Nav (Field6) — 네비게이션

aplctForm (신청서)

  • id (Key) — Primary key — NOT NULL
  • userid (Key2) — STRING — Foreign key → USER.id — NOT NULL
  • id_photo (Field) — TEXT
  • ceo_photo (Field2) — TEXT
  • accept (Field3) — BOOLEAN
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

brand_category (카데고리_브랜드)

  • categoryId (Key) — INTEGER — Foreign key → Category.id — NOT NULL
  • brandId (Key2) — INTEGER — Foreign key → BRAND.id — NOT NULL

user_order (회원 구매내역)

  • id (Key) — Primary key — NOT NULL

user_seller (회원 판매내역)

  • id (Key) — Primary key — NOT NULL
  • brand (Field) — STRING
  • prdName (Field2) — STRING
  • createdAt (Field3) — DATE