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)