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