2024 JEJU SR

Tables (8)

Client (고객정보(LV))

  • Dream ID (INT) — Primary key — NOT NULL
  • Client_Name (Field)
  • Client_Name(ENG) (Field4)
  • Clinet_Gender (Field5)
  • Store_Code (Field2)
  • Store_Name (Field3)
  • Host_Name (Field6)
  • Host_phone (Field7)

Dining (식사(LV))

  • Dream ID (PK) — Primary key — NOT NULL
  • JW_IN (FK)
  • D_Time (Field5)
  • D_Venue (Field)
  • D_Pax (Field2)
  • D_Age (Field4)
  • D_F/R (알러지)

Experience (체험(LV))

  • Dream ID (PK) — Primary key — NOT NULL
  • E_Code (Key2) — Primary key — NOT NULL
  • E1_Name (Field5)
  • E1_Date (Field)
  • E1_Time (Field2)
  • E1_Venue (Field10)
  • E2_Name (Field6)
  • E2_Date (Field3)
  • E2_Time (Field4)
  • E2_Venue (Field11)
  • E3_Name (Field7)
  • E3_Date (Field8)
  • E3_Time (Field9)
  • E3_Venue (Field12)

Flight (항공(QOOM))

  • Dream ID (PK) — Primary key — NOT NULL
  • F_IN_NO (Field)
  • F_IN_Date (Field3)
  • F_IN_ATime (Field7)
  • F_IN_DTime (Field4)
  • F_OUT_NO (Field6)
  • F_OUT_Date (Field5)
  • F_OUT_Time (Field2)

JW Hotel (호텔(JW))

  • Dream ID (PK) — Primary key — NOT NULL
  • JW_CSR_LV (Key) — Primary key — NOT NULL
  • JW_CSR_Add (Key2) — Primary key — NOT NULL
  • JW_IN (Field4)
  • JW_OUT (Field6)
  • JW_Pax (Field7)
  • JW_Rtype (Field2)
  • JW_Btype (Field)
  • JW_Add_IN (Field5)
  • JW_Add_OUT (Field3)
  • JW_Car (Field8)

Session (세션(LV))

  • DreamID (PK) — Primary key — NOT NULL
  • S_Date (Field)
  • S_Time (Field2)

Transportation (차량(QOOM))

  • DreamID (Key) — Primary key — NOT NULL
  • Pickup_Date (Field5)
  • Pickup_Time (Field)
  • Pickup_Place (Field3)
  • Sending_Date (Field6)
  • Sending_Time (Field2)
  • Sending_Place (Field4)

Welcome pack (선물(LV))

  • Dream ID (PK) — Primary key — NOT NULL
  • W_Initial (Field3)
  • W_Date (Field)
  • W_Pax (Field2)