FINIT_NEW

Tables (6)

T_Group (그룹)

  • UserIdx (Key) — INT(IDENTITY) — Foreign key → T_User.UserIdx — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • ParentIdx (parent index) — INT
  • GroupIdx (group index) — INT(IDENTITY)
  • Depth (depth) — INT
  • Name (name) — NVARCHAR(50)

T_GroupUser (유저 소속)

  • UserIdx (Key) — INT(IDENTITY) — Foreign key → T_User.UserIdx — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDTd (delete datetime) — DATETIME
  • GroupUserIdx (group user index) — INT(IDENTITY)
  • UserIdx (user index) — INT
  • GroupIdxg (group index) — INT

T_Toilet (화장실)

  • ToiletIdx (Key) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • LastUseDT (last use datetime) — DATETIME
  • Floor (floor) — INT
  • Gender (gendet) — CHAR(1)
  • Status (status) — INT

T_ToiletLog (화장실 사용 이력 로그)

  • ToiletLogInx (toilet log index) — INT(INDENTITY) — Primary key — NOT NULL
  • ToiletIdx (Key) — INT(IDENTITY) — Foreign key → T_Toilet.ToiletIdx — NOT NULL
  • RegDT (register datetime) — DATETIME
  • ToiletIdx (toilet index) — INT
  • Status (화장실 상태) — INT

T_ToiletNotifyReservation (화장실 알림 예약)

  • ToiletIdx (Key2) — INT(IDENTITY) — Foreign key → T_Toilet.ToiletIdx — NOT NULL
  • UserIdx (Key) — INT(IDENTITY) — Foreign key → T_User.UserIdx — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • CancelDT (cancel datetime) — DATETIME
  • NotifyDT (notify datetime) — DATETIME
  • ToiletNotifyReservationIdx (toilet notify reservation index) — INT(IDENTITY)
  • ToiletIdx (toilet index) — INT
  • UserIdx (user index) — INT

T_User (유저)

  • UserIdx (Key) — INT(IDENTITY) — Primary key — NOT NULL
  • RegDT (register datetime) — DATETIME
  • DelDT (delete datetime) — DATETIME
  • Id (id) — VARCHAR(20)
  • Name (name) — NVARCHAR(5)
  • Password (password) — VARCHAR(200)
  • Gender (gender) — CHAR(1)
  • OSType (os type) — INT
  • PushKey (pushkey) — VARCHAR(200)