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)