폰라인_어드민
테이블 (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