simplemarket
Tables (4)
ADMIN (관리자계정)
- ADMINID — Primary key — NOT NULL
- ADMINPW
CUSTOMER (회원정보)
- CUSTOMERID — Primary key — NOT NULL — 회원아이디
- CUSTOMERPW — NOT NULL — 회원계정비밀번호
- NAME — 회원이름
- PHONE — 회원전화번호
- BIRTHDATE — 회원생년월일
- ADDRESS
- INDATE — DATE — 회원가입일
PRODUCT (상품정보)
- PRODUCTSEQ — Primary key — NOT NULL
- NAME
- QUANTITY — NUMBER
- PRICE — NUMBER
- COMMENTS — 상품설명
- INDATE — DATE
SOLD (구매정보)
- SOLDSEQ — Primary key — NOT NULL
- CUSTOMERID — Foreign key → CUSTOMER.CUSTOMERID — NOT NULL — 회원아이디
- PRODUCTSEQ — Foreign key → PRODUCT.PRODUCTSEQ — NOT NULL
- INDATE — DATE
- QUANTITY — NUMBER