MobileShop

Tables (12)

admin (관리자페이지 관리자 정보)

  • ID (id) — int(11) — Primary key — NOT NULL
  • admin_id — varchar(45)
  • pw — varchar(45)
  • name — varchar(45)
  • company — varchar(100)
  • part — varchar(100)
  • permission — int(11)
  • dt_create — datetime
  • dt_delete — datetime

agreement (약관)

  • ID (id) — int(11) — Primary key — NOT NULL
  • provider — int(11)
  • title (tiltle) — varchar(100)
  • content — text
  • dt_create — datetime
  • dt_delete — datetime

apply_history (프로모션 신청 히스토리)

  • id — int(11) — Primary key — NOT NULL
  • promotion_apply — int(10)
  • admin — int(10)
  • type — varchar(20)
  • before_val — varchar(200)
  • after_val — varchar(200)
  • dt_create — datetime

apply_memo (신청시 메모)

  • id — int(11) — Primary key — NOT NULL
  • memo — text
  • admin (int(10)) — int(10)
  • dt_create — datetime
  • promotion_apply — int(10)

faq

  • id — int(11) — Primary key — NOT NULL
  • question — varchar(200)
  • answer — varchar(200)
  • dt_create — datetime
  • dt_delete — datetime

files (파일정보)

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(100)
  • url — varchar(255)
  • dt_create — datetime

logo (회사로고)

  • id — int(11) — Primary key — NOT NULL
  • company — varchar(200)
  • file — int(11)
  • dt_create — datetime
  • dt_delete — datetime

phone (폰정보)

  • id — int(11) — Primary key — NOT NULL
  • provider — int(11)
  • manufacturer — int(11)
  • name — varchar(100)
  • model — varchar(100)
  • price — int(11)
  • img — int(11)
  • description — text
  • dt_create — datetime
  • dt_delete — datetime
  • storage — varchar(5)
  • master_key — int(10)
  • isvalid — varchar(1)

phone_color (폰 칼라)

  • id — int(11) — Primary key — NOT NULL
  • phone — int(11)
  • color — varchar(50)
  • dt_create — datetime
  • dt_delete — datetime
  • isvalid — varchar(1)

phone_master (폰 마스터 정보)

  • id — int(11) — Primary key — NOT NULL
  • manufacturer — int(11)
  • name — varchar(100)
  • model — varchar(100)
  • img — int(11)
  • description — text
  • dt_create — datetime
  • dt_delete — datetime
  • isvalid — varchar(1)

plan (요금제)

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(100)
  • provider — int(11)
  • name — varchar(100)
  • period — int(11)
  • discount — int(11)
  • fee — int(11)
  • info_voice — varchar(100)
  • info_sms — varchar(100)
  • info_data — varchar(100)
  • dt_create — datetime
  • dt_delete — datetime
  • isvalid — varchar(1)

policy (CopyOf요금제)

  • id — int(11) — Primary key — NOT NULL
  • title — varchar(100)
  • provider — int(11)
  • phone — varchar(100)
  • period — int(11)
  • discount — int(11)
  • fee — int(11)
  • info_voice — varchar(100)
  • info_sms — varchar(100)
  • info_data — varchar(100)
  • dt_create — datetime
  • dt_delete — datetime
  • isvalid — varchar(1)