vv

Tables (9)

golves (Untitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • region_id (Key2) — NOT NULL — Foreign key → regions.id — NOT NULL
  • name (Field) — NOT NULL
  • address (Field3) — NOT NULL
  • website (Field4) — NULLABLE
  • phonenum (Field5) — NULLABLE

nat_tours (CopyOfCopyOfCopyOfUntitled42)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • region_id (Key2) — NOT NULL — Foreign key → regions.id — NOT NULL
  • name (Field) — NOT NULL
  • price (Field2) — NULLABLE
  • address (Field4) — NULLABLe
  • couple (Field3) — NOT NULL
  • one_day (Field5) — NOT NULL
  • tour (Field6) — NOT NULL
  • no_caddy (Field7) — NOT NULL

regions (CopyOfCopyOfUntitled42)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL

reservations (CopyOfUntitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • manager_id (Key2) — NOT NULL — Foreign key → users.id — NOT NULL
  • tag_id (Key3) — NOT NULL — Foreign key → tags.id — NOT NULL
  • golf_id (Key4) — NOT NULL — Foreign key → golves.id — NOT NULL
  • tee_time (Field) — NOT NULL
  • instant (Field7) — NOT NULL
  • user_id (Field2) — NULLABLE
  • payment (Field8) — NULLABLE
  • upload_at (Field5) — NOT NULL
  • created_at (Field3) — NOT NULL
  • course (Field4) — NOT NULL
  • price (Field6) — NOT NULL

reserved_nat_tours (CopyOfC2)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • nat_tour_id (Key2) — NOT NULL — Foreign key → nat_tours.id — NOT NULL
  • user_id (Key3) — NOT NULL — Foreign key → users.id — NOT NULL
  • tour_time (Field) — NOT NULL
  • payment (Field2) — NOT NULL

resv_lists (Untitled)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • ttime (Field) — NOT NULL
  • manager_id (Field3) — NOT NULL
  • upload_time (Field5) — NOT NULL
  • toWhere (Field6) — NOT NULL
  • instant (Field7) — NOT NULL
  • golf_id (Field4) — NOT NULL

sellable_nat_tours (C)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • nat_tour_id (Key2) — NOT NULL — Foreign key → nat_tours.id — NOT NULL
  • tour_time (Field) — NOT NULL

tags (CopyOfUntitled42)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL

users (CopyOfUntitled4)

  • id (Key) — NOT NULL — Primary key — NOT NULL
  • name (Field) — NOT NULL
  • email (Field2) — NOT NULL
  • password (Field3) — NOT NULL
  • remember_token (Field4) — NULLABLE
  • created_at (Field5) — NULLABLE
  • updated_at (Field6) — NULLABLE
  • phonenum (Field7) — NOT NULL
  • birthdate (Field8) — NULLABLE
  • pos (Field9) — NOT NULL