planner

Tables (4)

code (Untitled)

  • code (Key) — VARCHAR(6) — Primary key — NOT NULL
  • codeName (Field2) — NVARCHAR(50)

plan (Untitled2)

  • planID (Key) — Primary key — NOT NULL
  • contryID (Key2) — VARCHAR(6) — Foreign key → code.code — NOT NULL
  • userID (int) — Autoincrease — Foreign key → user.userID — NOT NULL
  • themeID (Field2) — VARCHAR(6)
  • planName (Field) — VARCHAR(50)
  • designed (Field3) — VARCHAR(1)
  • createDate (Field4) — DateTime
  • updateDate (Field5) — DateTime

planPiece (Untitled3)

  • pieceID (Key) — int — Primary key — NOT NULL
  • planID (Key2) — Foreign key → plan.planID — NOT NULL
  • locationID (Key22) — VARCHAR(6) — Foreign key → plan.contryID — NOT NULL
  • name (Field) — nVARCHAR(50)
  • latitude (Field2) — VARCHAR(50)
  • longitade (Field3) — VARCHAR(50)
  • themeCode (Field4) — VARCHAR(6)
  • createDate (Field5) — DateTime
  • updateDate (Field6) — DateTime

user (유저정보)

  • userID (int) — Autoincrease — Primary key — NOT NULL
  • nickName (nvarchar(50))
  • loginType (nvarchar(10))
  • socialId (nvarchar(20))
  • createDate (DateTime) — DateTime
  • updateDate (Field) — DateTime