# Database Schama

---
title: Hello Title
config:
  theme: base
  themeVariables:
    primaryColor: "#00ff00"
---
erDiagram
    "Movie" {
        string Movie_ID PK
        string Type
        string[] Actors FK
        int Rate
        string Director
        string Name
        int Duration
        string image  "此為目錄"   
    }
    "Movie Screening Schedule" {
        string Play_ID PK
        Date date
        timestamp time
        int Cinema_NO
        string Movie_ID
    }
    "Employee" {
        string Employee_ID PK
        string Position
        string Name 
    }
    "Order"{
        string Order_ID PK
        Date Order_Date
        Date Ship_Date
        int Quantity
        int status "0代表未使用 1代表已使用"
        Array[string] Seat_Info
        int Price
        string Play_ID FK
        string Coupon_ID FK
    }
    "Notification"{
        string Notify_ID PK
        string Message
        string[] Range
    }
    "Coupon"{
        string Coupon_ID PK
        int Fee
        string Reason
        string Condition
        Date Start_Date
        Date End_Date
    }
    "Customer"{
        string ID_card PK
        string Name
        string Sex
        Date Register_date
        string Email
        string Address
    }
    "Theater"{
        string  Name PK
        string  Business_Address
    }
    "Theater" ||..o{ "Movie Screening Schedule" : "own"
    "Theater" }|..|{ "Movie" : "own"
    "Theater" }|..|{"Employee":"admin"
    "Theater" }|..|{"Notification":"admin"
    "Theater" }|..|{"Customer":"Client"
    "Theater" }|..|{"Order":"Manage"
    "Customer" }|..|{"Coupon":"Own"