pizza
Tables (8)
board
- no — int — Primary key — NOT NULL
- mart_no — int — Foreign key → mart.no — NOT NULL
- mno — int — Foreign key → member.no — NOT NULL
- title — varchar
- content — text
- writer — varchar
- email — varchar
- created_date — timestamp
mart
- no — int — Primary key — NOT NULL
- name — varchar
- parent_no — int
member
- no — int — Primary key — NOT NULL
- member — varchar
- password — varchar
- email — varchar
- phone — varchar
- birth — varchar
- name — varchar
myrole
- member_no — int — Foreign key → member.no — NOT NULL
- role — varchar
order
- no — int — Primary key — NOT NULL
- date — int
- size — int
- name — int
orderitem
- mno — int — Foreign key → member.no — NOT NULL
- pno — int — Foreign key → products.no — NOT NULL
- no (no2) — int — Foreign key → order.no — NOT NULL
products
- no — int — Primary key — NOT NULL
- name — varchar
- content — text
- price — int
- created_date — timestamp
products_image
- no — int — Primary key — NOT NULL
- gno — int — Foreign key → products.no — NOT NULL
- bucket_key — varchar
- org_name — varchar
- def — bit