project1

Tables (4)

admin (관리자)

  • admin_id (관리자ID) — INT — Primary key
  • admin_name (관리자명) — VARCHAR(100) — NOT NULL
  • email (이메일) — VARCHAR(100) — NOT NULL
  • password (비밀번호) — VARCHAR(100) — NOT NULL
  • phone (전화번호) — VARCHAR(20)
  • address (주소) — VARCHAR(50)

brand (브랜드)

  • brand_id (브랜드ID) — INT — Primary key
  • name (브랜드명) — VARCHAR(100) — NOT NULL
  • description (브랜드 설명) — TEXT
  • admin_id (등록 관리자 ID) — INT
  • admin_id (관리자ID) — INT — Foreign key → admin.admin_id

product (상품)

  • product_id (상품ID) — INT — Primary key
  • title (상품명) — VARCHAR(255) — NOT NULL
  • description (상품 설명) — TEXT
  • price (가격) — INT — NOT NULL
  • stock (재고 수량) — INT
  • category_id (카테고리 ID) — INT
  • status (상품 상태) — VARCHAR(50)
  • brand_id (브랜드 ID) — INT
  • admin_id (관리자ID) — INT — Foreign key → admin.admin_id

user (사용자)

  • user_id (사용자ID) — INT — Primary key
  • username (사용자명) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • phone (전화번호) — VARCHAR(20)
  • address (주소) — VARCHAR(50)