뮤짘컬예매

테이블 (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)