test

Tables (3)

customer (고객)

  • no (Key) — Primary key — NOT NULL
  • name (Field)
  • id (Field2)
  • pwd (Field3)
  • email (Field4)
  • tel (Field5)
  • regdate (Field6)

movie (영화)

  • no (Key) — Primary key — NOT NULL
  • name (Field)
  • genre (Field2)
  • opendate (Field3)

reserve (예매)

  • no (Key) — Primary key — NOT NULL
  • cno (Key2) — Foreign key → customer.no — NOT NULL
  • mno (Key3) — Foreign key → movie.no — NOT NULL
  • price (Field3)
  • resdate (Field4)