driveryERD

Tables (7)

CUST (회원)

  • custno — int(10) — Primary key — NOT NULL
  • id (not null)
  • password (char(30))
  • name (char(10)) — 이름
  • member (int(10)) — 맴버
  • address (char(100)) — 주소
  • email (Field7) — 이메일
  • regdate (now()) — 등록일

FAQ (고객센터)

  • faqno (Key) — Primary key — NOT NULL
  • myfaqno (Key2) — Foreign key → myFAQ.myfaqno — NOT NULL
  • custno (Key3) — 고객번호 — Foreign key → myFAQ.custno — NOT NULL

Market (가게)

  • marketno — int(10) — Primary key — NOT NULL
  • custno (foreign_cust) — int(10) — Foreign key → CUST.custno — NOT NULL
  • Key — Foreign key → kategori.Key — NOT NULL
  • marketname (Field)
  • marketaddress (Field2)
  • Field3
  • regdate (Field4) — 등록일
  • hit (Field5) — 조회

Reivew (리뷰)

  • rno (Key) — int(10) — Primary key — NOT NULL
  • marketno — int(10) — Foreign key → Market.marketno — NOT NULL
  • custno (foreign_cust) — int(10) — Foreign key → Market.custno — NOT NULL
  • Key (Key2) — Foreign key → Market.Key — NOT NULL
  • content (Field) — char(100)
  • star (Field2) — int(10)
  • Field3

kategori (가게종류)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

myFAQ (내고객요청)

  • myfaqno (Key) — 내고객요청번호 — Primary key — NOT NULL
  • custno (Key3) — 고객번호 — Foreign key → CUST.custno — NOT NULL
  • content (Field) — 내용
  • regdate (date) — 등록일

star (찜목록)

  • Key — Primary key — NOT NULL
  • Field
  • Field2