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)