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