Golf

Tables (7)

Alarm

  • AlarmID — int — Primary key — NOT NULL
  • ReservationID_1 — int — Foreign key → Reservation.ReservationID — NOT NULL
  • ReservationID_2 — int — Foreign key → Reservation.ReservationID
  • AlarmMessage — varchar(100)

Post

  • PostID — int — Primary key — NOT NULL
  • PosterName — varchar(20) — Foreign key → User.UserID — NOT NULL
  • StaffID — varchar(20) — Foreign key → Staff.StaffID — NOT NULL
  • PostingDate — varchar(20) — NOT NULL
  • PostingTime — varchar(20) — NOT NULL
  • PostType — varchar(10) — NOT NULL
  • ViewCount — int — NOT NULL
  • IsSecretPost — int — NOT NULL

Reservation

  • ReservationID — int — Primary key — NOT NULL
  • UserID — varchar(20) — Foreign key → User.UserID — NOT NULL
  • RoomID — int — Foreign key → Room.RoomID — NOT NULL
  • ReservationTime — varchar(20) — Foreign key → Time.TimeID — NOT NULL
  • ReservationDate — varchar(20) — NOT NULL
  • ReservationType — varchar(10) — NOT NULL

Room

  • RoomID — int — Primary key — NOT NULL
  • Status — int — NOT NULL

Staff

  • StaffID — varchar(20) — Primary key — NOT NULL
  • StaffPW — varchar(20) — NOT NULL
  • Name — varchar(10) — NOT NULL
  • PhoneNum — varchar(13) — NOT NULL
  • StaffCode — varchar(10) — NOT NULL
  • WorkingTime — varchar(20) — Foreign key → Time.TimeID — NOT NULL

Time

  • TimeID — varchar(20) — Primary key — NOT NULL

User

  • UserID — varchar(20) — Primary key — NOT NULL
  • HomeNum — varchar(10) — NOT NULL
  • UserPW — varchar(20) — NOT NULL
  • Name — varchar(10) — NOT NULL
  • PhoneNum — varchar(13) — NOT NULL