proj
Tables (15)
CS Board (Untitled7)
- Id (Key) — number — Primary key — NOT NULL
- E-mail (Key2) — nvarchar — Foreign key → USERS.E-mail — NOT NULL
- title (Field) — nvarchar
- content (Field2) — nvarchar
- Answer (Field3) — nvarchar
- PostDate (Field4) — Date
Chatbot (Untitled9)
- id (Key) — number — Primary key — NOT NULL
- Inquery (Field) — nvarchar
- Answer (Field2) — nvarchar
ChattingRoom (Untitled5)
- id (Key) — number — Primary key — NOT NULL
- C_E-mail (Key23) — nvarchar — Foreign key → Customer.E-mail — NOT NULL
- G_E-mail (Key22) — nvarchar — Foreign key → Guide.E-mail — NOT NULL
- Time (Field) — Timestamp
Customer (Untitled)
- E-mail (Key2) — nvarchar — Foreign key → USERS.E-mail — NOT NULL
- name (Field2) — nvarchar(10)
DayRoute (Untitled13)
- ID (Key) — number — Primary key — NOT NULL
- P_Id (Key2) — number — Foreign key → Product Board.id — NOT NULL
- coordinate (Field) — nvarchar
- Day (Field2) — number
Guide (untitle)
- E-mail (Key2) — nvarchar — Foreign key → USERS.E-mail — NOT NULL
- name (Field2) — nvarchar
- certification (Field4) — nvarchar
Messages (Untitled12)
- ID (Key) — number — Primary key — NOT NULL
- CR_Id (Key2) — number — Foreign key → ChattingRoom.id — NOT NULL
- Send_ID (Field) — nvarchar
- message (Field2) — nvarchar
- files (Field3) — nvarchar
- Send_TimeStamp (Field4) — TimeStamp
- status (Field5) — nvarchar
- Field6
Payment (Untitled4)
- id (Key) — number — Foreign key → Product Board.id — NOT NULL
- G_E-mail (Key22) — nvarchar — Foreign key → Product Board.G_E-mail — NOT NULL
- payment Time (Field) — TimeStamp
- price (Field2) — number
- status (Field3) — nvarchar
- payment method (Field4) — nvarchar
Product Board (Untitled2)
- id (Key) — number — Primary key — NOT NULL
- G_E-mail (Key22) — nvarchar — Foreign key → Guide.E-mail — NOT NULL
- title (Field) — nvarchar
- content (Field2) — nvarchar
- city (Field3) — nvarchar
- postdate (Field4) — date
- files (d) — nvarchar
- status (Field5) — nvarchar
- Field6
Product Likey (Untitled3)
- C_E-mail (Key23) — nvarchar — Foreign key → Customer.E-mail — NOT NULL
- P_ID (Key) — number — Foreign key → Product Board.id — NOT NULL
Product Review (Untitled6)
- id (Key) — number — Primary key — NOT NULL
- E-mail (Key22) — nvarchar — Foreign key → Product Board.G_E-mail — NOT NULL
- Key (Key2) — Foreign key → Product Board.id — NOT NULL
- score (Field) — number
Report (Untitled14)
- Id (Key) — number — Primary key — NOT NULL
- E-mail (Key2) — nvarchar — Foreign key → USERS.E-mail — NOT NULL
- id (Key3) — number — Foreign key → Product Board.id — NOT NULL
- content (Field) — nvarchar
- list1 (Field2)
- list2 (Field3)
- list3 (Field4)
Scheduling (Untitled11)
- G_E-mail (Key2) — nvarchar — Foreign key → Guide.E-mail — NOT NULL
- C_E-mail (Key22) — nvarchar — Foreign key → Customer.E-mail — NOT NULL
- P_Id (Key) — nvarchar — Foreign key → Product Board.id — NOT NULL
- Start Day (Field) — TimeStamp
- End Day (Field2) — TimeStamp
Service Evaluation (Untitled10)
- id (Key) — number — Foreign key → Product Board.id — NOT NULL
- G_E-mail (Key22) — nvarchar — Foreign key → Product Board.G_E-mail — NOT NULL
- comment (Field) — nvarchar
- score (Field2) — number
- Field3 — nvarchar
- Field4
USERS (Untitled8)
- E-mail (Key) — nvarchar — Primary key — NOT NULL
- Password (Field) — nvarchar
- name (Field2) — nvarchar
- Tel (Field3) — nvarchar
- Role (Field4) — nvarchar
- InterCity (Field5) — nvarcharR
- RegiDate (Field6) — Date