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)