spatium-advanced
Tables (6)
Community
- COM_ID — VARCHAR2(36) — Primary key — NOT NULL
- MEM_ID — VARCHAR2(36) — Foreign key → MEMBER.MEM_ID — NOT NULL
- COM_REPLY — VARCHAR2(300)
- COM_TITLE — VARCHAR2(100)
- COM_LINK — VARCHAR2(100)
- Field
MEMBER
- MEM_ID — VARCHAR2(36) — Primary key — NOT NULL
- MEM_NICK — VARCHAR2(15) — NOT NULL
- MEM_EMAIL — VARCHAR2(50) — NOT NULL
- MEM_PASS — VARCHAR2(60)
- MEM_BIR — VARCHAR2(10) — NOT NULL
- MEM_SEX — VARCHAR2(10) — NOT NULL — '0 : 남자 1 : 여자',
- MEM_IMG — BLOB
- PROVIDER — VARCHAR2(10) — NOT NULL — 'LOCAL GOOGL
- PROVIDER_USER_ID — VARCHAR2(50) — Google sub 또는 Apple sub 저장용
PROJECT
- PROJ_CODE — VARCHAR2(36) — Primary key — NOT NULL
- PROJ_MEM — VARCHAR2(36) — Foreign key → MEMBER.MEM_ID — NOT NULL
- PROJ_NAME — VARCHAR2(50)
- PROJ_DATE — TIMESTAMP
REFRESH_TOKEN
- TOKEN_ID — VARCHAR2(36) — Primary key — NOT NULL
- MEM_ID — VARCHAR2(36) — Foreign key → MEMBER.MEM_ID — NOT NULL
- TOKEN_HASH — VARCHAR2(64) — NOT NULL
- EXPIRES_AT — TIMESTAMP — NOT NULL
- REVOKED — NUMBER(1) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
ROOM
- ROOM_ID — VARCHAR2(36) — Primary key — NOT NULL
- ROOM_PROJ — VARCHAR2(36) — Foreign key → PROJECT.PROJ_CODE — NOT NULL
- ROOM_PATH — VARCHAR2(300) — NOT NULL
- ROOM_NAME — VARCHAR2(30)
- ROOM_AREA — VARCHAR2(10)
- ROOM_CREATED — TIMESTAMP
- ROOM_MODIFIED — TIMESTAMP
furniture
- FUR_CODE — VARCHAR2(50) — Primary key — NOT NULL
- FUR_MEM — VARCHAR2(36) — Foreign key → MEMBER.MEM_ID
- FUR_name — VARCHAR2(100) — NOT NULL
- FUR_name_kr — VARCHAR2(100)
- FUR_category — VARCHAR2(50) — NOT NULL
- FUR_category_kr — VARCHAR2(50) — NOT NULL
- FUR_width — VARCHAR2(10) — NOT NULL
- FUR_height — VARCHAR2(10) — NOT NULL
- FUR_depth — VARCHAR2(10) — NOT NULL
- FUR_PATH — VARCHAR2(500) — NOT NULL
- FUR_is_default — VARCHAR2(1) — NOT NULL
- FUR_is_active — VARCHAR2(1) — NOT NULL