adf

테이블 (8)

Untitled

  • 부서번호 (Key) — 기본 키 — NOT NULL
  • 부서명 (Field)
  • 위치 (Field2)

members

  • member_id — INT
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • address — VARCHAR(255)
  • created_at — TIMESTAMP

order_items

  • order_item_id — INT
  • order_id — INT — 외래 키 → orders.order_id — NOT NULL
  • product_id — INT — 외래 키 → products.product_id — NOT NULL
  • order_price — INT — NOT NULL
  • count — INT — NOT NULL

orders

  • order_id — INT
  • member_id — INT — 외래 키 → members.member_id — NOT NULL
  • order_date — TIMESTAMP
  • status — VARCHAR(20)

posts

  • post_id — INT
  • user_id — INT — 외래 키 → users.user_id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP

products

  • product_id — INT
  • name — VARCHAR(200) — NOT NULL
  • price — INT — NOT NULL
  • stock_quantity — INT — NOT NULL
  • description — TEXT

users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

사원 (emp)

  • 사원번호 (Key) — 기본 키 — NOT NULL
  • Field
  • Field2
  • Field3
  • 부서번호 (Key2) — 외래 키 → Untitled.부서번호 — NOT NULL