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