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