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