PLANNER
Tables (5)
ESPENSES (CopyOfPLAN)
- ENO (PNO) — INT(11) — Primary key — NOT NULL
- ETITLE (PNAME) — VARCHAR(64) — NOT NULL
- COST (REGDATE) — INT — NOT NULL
- REGDATE (START_DATE) — DATETIME — NOT NULL
- UNO — INT(11) — Foreign key → USER.UNO — NOT NULL — UNIQUE
- GNO — INT(11) — Foreign key → TRAVEL_GROUP.GNO — NOT NULL
GROUP_MEMBER
- UNO — INT(11) — Foreign key → USER.UNO — NOT NULL — UNIQUE
- GNO — INT(11) — Foreign key → TRAVEL_GROUP.GNO — NOT NULL
- ISWRITABLE (WRITABLE) — BOOLEAN — NOT NULL
- ISOWNER (OWNER) — BOOLEAN — NOT NULL
PLAN
- PNO — INT(11) — Primary key — NOT NULL
- PNAME — VARCHAR(64) — NOT NULL
- REGDATE — DATETIME — NOT NULL
- COMMENT — TEXT
- TYPE — VARCHAR(32) — NOT NULL
- START_DATE — DATE — NOT NULL
- LOC_LAT (Field) — FLOAT
- LOC_LNG (Field2) — FLOAT
- START_TIME — TIME — NOT NULL
- UNO — INT(11) — Foreign key → USER.UNO — NOT NULL — UNIQUE
- GNO — INT(11) — Foreign key → TRAVEL_GROUP.GNO — NOT NULL
TRAVEL_GROUP
- GNO — INT(11) — Primary key — NOT NULL
- GNAME — VARCHAR(64) — NOT NULL
- REGDATE — DATETIME — NOT NULL
- CHGDATE (UPDATE) — DATETIME — NOT NULL
- PHOTO_URL — VARCHAR(512)
USER
- UNO — INT(11) — Primary key — NOT NULL — UNIQUE
- UUID — VARCHAR(64) — NOT NULL — PK
- LOGIN_ID — VARCHAR(32) — NOT NULL — UNIQUE
- PW (PASSWORD) — VARCHAR(256) — NOT NULL
- SALT — VARCHAR — NOT NULL
- NICKNAME — VARCHAR(64) — NOT NULL
- EMAIL — VARCHAR(256) — NOT NULL
- PHOTO_URL — VARCHAR(512)
- REGDATE — DATETIME — NOT NULL