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