PhoneTech
Tables (20)
Liview (리뷰)
- id (Key3) — Primary key — NOT NULL
- userid (Key) — Foreign key → user.id — NOT NULL
- productid (Key2) — Foreign key → product.id — NOT NULL
- title (Field)
- product (Field2)
- star (Field3)
- contents (Field4)
banner (배너)
- id (Key) — Primary key — NOT NULL
- image (Field)
- order (Field2)
- ison (Field3)
- validate (Field4)
boardrec (사전예약)
- id (Key) — Primary key — NOT NULL
- contents (Field)
- images (Field2)
- url (Field3)
cardlist (제휴카드)
- id (Key) — Primary key — NOT NULL
- telecomid (Key2) — Foreign key → telecom.id — NOT NULL
- name (카드이름)
- price (할인금\)
- tel (고객센터 전화번호)
- images (카드이미지)
- telecomname (텔레콤이름)
category (카테고리)
- id (Key) — Primary key — NOT NULL
- name (Field)
- order (filed2)
colorprice (색상별가격)
- id (Key) — Primary key — NOT NULL
- productid (Key2) — Foreign key → product.id — NOT NULL
- name (색상명)
- price (가격)
hardprice (용량별 가격)
- id (Key) — Primary key — NOT NULL
- productid (Key2) — Foreign key → product.id — NOT NULL
- name (용량별 가격)
- price (가격)
messages (푸시메세지리스트)
- id (Key) — Primary key — NOT NULL
- userid (리스트보유 유저아이디) — Foreign key → user.id — NOT NULL
- title (타이틀)
- subtitle (서브타이틀)
order (주문내역)
- id (Key) — Primary key — NOT NULL
- userid (Key2) — Foreign key → user.id — NOT NULL
- storeid (Key3) — Foreign key → store.id — NOT NULL
- name (이름)
- birthday (생일)
- tel (개통 휴대폰번호)
- tel1 (추가연락처)
- email (이메일)
- child (성년/미성년자여부)
- receiver (받으시는분)
- receivercall (배송연락처)
- zip (주소)
- zipinfo (상세주소)
- isvalidate (승인여부)
- validate (체크박스용)
- memo (요청사항)
- usim (유심타입)
orderProduct (주문상품정보)
- id (Key) — Primary key — NOT NULL
- orderid (Key2) — Foreign key → order.id — NOT NULL
- id (Key3) — Foreign key → order.storeid — NOT NULL
- nowtel (사용중인통신사 사용중인통신사 1,2,3,4 SKT LG U KT 알뜰폰)
- willtel (사용할통신사 사용중인통신사 1,2,3,4 SKT LG U KT 알뜰폰)
- saletype (할인방법)
- pricetype (요금제)
- monthuse (구매방법)
- salemonth (할부원금)
- marketprice (출고가)
- openprice (공시할인)
- dcprice (dc가격)
- monttype (할부 기간)
- cardsale (제휴카드 할인)
- cardname (제휴카드 이름)
- price (판매가)
- monthprice (할부금(월 납부액))
- productname (상품이름)
- colorname (색상)
- hard (하드)
- pricetypeprice (요금제 결제비)
product (상품)
- id (Key) — Primary key — NOT NULL
- categoryid (카테고리명) — Foreign key → category.id — NOT NULL
- promotionid (Key2) — Foreign key → promotion.id — NOT NULL
- name (기기명)
- images (프로덕트이미지)
- validate (체크박스용)
- marketprice (출고가)
- giga (네트워크 기가)
productboard (상품상세페이지)
- id (Key) — Primary key — NOT NULL
- productid (프로덕트아이디) — Foreign key → product.id — NOT NULL
- contents (제품정보)
promotion (프로모션)
- id (Key) — Primary key — NOT NULL
- title (Field)
- type (Field3)
- validate (Field4)
- order (Field2)
promotionsale (프로모션세일)
- id (Key) — Primary key — NOT NULL
- telecomid (텔레콤아이디) — Foreign key → telecom.id — NOT NULL
- title (타이틀)
- subtitle (서브타이틀)
- perce (할인률)
store (상점)
- id (Key) — Primary key — NOT NULL
- name (Field)
- code (Field2)
- tel (Field3)
- price (Field4)
- email (Field5)
- sale (Field6)
- dc (Field7)
- slaea (Field8)
telecom (통신사 리스트입니다)
- id (Key) — Primary key — NOT NULL
- name (통신사이름)
telecom_product (통신사별 기기)
- id (Key) — Primary key — NOT NULL
- telecomid (텔레콤 외래키) — Foreign key → telecom.id — NOT NULL
- productid (프로덕트 외래키) — Foreign key → product.id — NOT NULL
- dc_move_price (통신사별 기기이전비)
- dc_change_price (통신사별 기기 전환비)
- dc_sales_price (공시 지원 할인금)
- dc_choose_price (선택 약정 할인금)
typetelecom (CopyOf요금제)
- id (Key) — Primary key — NOT NULL
- telecomid (Key2) — Foreign key → telecom.id — NOT NULL
- telecomname (통신사이름)
- name (요금제명)
- pricemonth (월별납부금액)
- datarem (데이터용량)
- callrem (음성통화용량)
- smsrem (문자용량)
typetelecom_category (요금제 카테고리)
- id (Key) — Primary key — NOT NULL
- title (Field)
- giga (Field2)
- option (Field3)
user (유저)
- id (Key) — Primary key — NOT NULL
- storeid (Key2) — Foreign key → store.id — NOT NULL
- email (Field)
- password (Field2)
- name (Field3)
- useremail (Field4)
- access (Field5)
- gm (Field6)
- validate (Field7)
- devicetoken (Field8)
- office (Field9)
- rank (Field10)
- image (Field11)
- child (Field12)
- birthday (Field13)