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