폰라인_어드민

테이블 (9)

CARD (카드)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • pageid (Key2) — INTEGER — 외래 키 → Page.id — NOT NULL
  • title (Field) — STRING
  • order (Field2)

CARD_BANNER (배너형)

  • id (Key2) — INTEGER — 기본 키 — NOT NULL
  • cardid (Key) — INTEGER — 외래 키 → CARD.id — NOT NULL
  • bg_pc_h (Field) — INTEGER
  • bg,_tablet_h (Field2) — INTEGER
  • bg_mobile_h (Field3) — INTEGER
  • bg_pc_i (Field4) — STRING
  • bg_tablet_i (Field5) — STRING
  • bg_mobile_i (Field6) — STRING
  • title (Field7) — TEXT
  • play_store_link (Field8) — STRING
  • app_store_link (Field9) — STRING
  • createdAt (Field10) — DATE
  • updatedAt (Field11) — DATE

CARD_DEVICE (디바이스)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • cardid (Key2) — INTEGER — 외래 키 → CARD.id — NOT NULL
  • top_title (Field) — TEXT
  • bottom_title (Field2) — TEXT
  • bg_pc_i (Field3) — STRING
  • bg_tablet_i (Field4) — STRING
  • bg_mobile_i (Field5) — STRING
  • bg_pc_h (Field6) — INTEGER
  • bg_tablet_h (Field7) — INTEGER
  • bg_mobile_h (Field8) — INTEGER
  • createdAt (Field9) — DATE
  • updatedAt (Field10) — DATE
  • devices (Field11) — JSON

CARD_IMAGE (이미지형)

  • id (Key) — 기본 키 — NOT NULL
  • cardid (Key22) — INTEGER — 외래 키 → CARD.pageid — NOT NULL
  • bg_pc_i (Field) — STRING
  • bg_mobile_i (Field2) — STRING
  • bg_tablet_i (Field3) — STRING
  • link (Field4) — STRING
  • bg_pc_h (Field5) — INTEGER
  • bg_mobile_h (Field6) — INTEGER
  • bg_tablet_h (Field7) — INTEGER
  • createdAt (Field8) — DATE
  • updatedAt (Field9) — DATE

CARD_ORDER (신청서형)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • cardid (Key2) — INTEGER — 외래 키 → CARD.id — NOT NULL
  • telecom (Field) — JSON
  • device (Field2) — JSON
  • title (Field5) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

CARD_REVIEW (리뷰형)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • cardid (Key22) — INTEGER — 외래 키 → CARD.pageid — NOT NULL
  • title (Field) — TEXT
  • bg_pc_i (Field2) — STRING
  • bg_mobile_i (Field3) — STRING
  • bg_tablet_i (Field4) — STRING
  • star (Field5) — INTEGER
  • create_date (Field6) — STRING
  • content (Field7) — STRING
  • review_i (Field8) — STRING
  • createdAt (Field9) — DATE
  • updatedAt (Field10) — DATE

DEVICE (기기)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • card_deviceid (Key2) — INTEGER — 외래 키 → CARD_DEVICE.id — NOT NULL
  • device_i (Field) — STRING
  • price (Field2) — STRING
  • device_n (Field3) — STRING
  • link (Field4) — STRING
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

Page (페이지)

  • id (Key) — INTEGER — 기본 키 — NOT NULL

REQUEST_TELECOM (신청서)

  • id (Key) — INTEGER — 기본 키 — NOT NULL
  • pageid (Key2) — INTEGER — 외래 키 → Page.id — NOT NULL
  • option (Field) — BOOLEAN
  • name (Field2) — STRING
  • tel (Field3) — STRING
  • telecom (Field4) — STRING
  • device (Field5) — STRING
  • createdAt (Field6) — DATE
  • updatedAt (Field7) — DATE