뮤짘컬예매
테이블 (3)
Member (member)
- Member_id (member_id) — INT(3) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(20)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(20)
- Passward (passward) — VARCHAR2(20)
Order (order)
- Order_id (order_id) — INT(11) — 기본 키 — NOT NULL
- Member_id (member_id) — INT(3) — 외래 키 → Member.Member_id — NOT NULL
- Seat_num (seat_num) — INT(3)
- Date (date) — DATE(YYYY-MM-DD)
- Buy_date (buy_date) — DATE(YYYY-MM-DD)
Posts (posts)
- Post_id (post_id) — INT(11) — 기본 키 — NOT NULL
- Member_id (member_id) — INT(3) — 외래 키 → Member.Member_id — NOT NULL
- Author (author) — VARCHAR(20)
- Date (date) — DATE(YYYY-MM-DD)
- Visits (visits) — INT(3)