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