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