GROUBY

Tables (13)

USER

  • Key (USER_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • Field (USER_NAME) — VARCHAR2(20)
  • Field (PASSWORD) — VARCHAR2(100)
  • Field (PHONE) — VARCHAR2(20)
  • Field (REG_DATE) — DATE
  • Field (MOD_DATE) — DATE

Untitled (FRIEND)

  • Key (USER_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • Key2 (FRIEND_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • Field (REG_DATE) — DATE

Untitled (GROUP)

  • Key (GROUP_ID) — INT — Primary key — NOT NULL
  • Field (GROUP_NAME) — VARCHAR2(100)
  • Field (REG_ID) — VARCHAR2(20)
  • Field (REG_DATE) — DATE
  • Field (MOD_DATE) — DATE

Untitled (GROUP_MEMBER)

  • Key (GROUP_ID) — INT — Primary key — NOT NULL
  • Field (USER_ID) — VARCHAR2(20) — Primary key
  • Field (REG_DATE) — DATE

Untitled (SPOT)

  • Key (SPOT_ID) — INT — Primary key — NOT NULL
  • Field (GROUP_ID) — INT
  • Field (SPOT_NAME) — VARCHAR2(50)
  • Field (REG_ID) — VARCHAR2(20)
  • Field (REG_DATE) — DATE
  • Field (MOD_DATE) — DATE

Untitled (RANK)

  • Key (SPOT_ID) — INT — Primary key — NOT NULL
  • Field (REG_ID) — VARCHAR2(20) — Primary key
  • Field (RANK_COMP_ID) — INT — Primary key
  • Field (RANK) — INT
  • Field (REG_DATE) — DATE

Untitled (RANK_COMP)

  • Field (RANK_COMP_ID) — INT
  • Field (RANK_COMP_NAME) — VARCHAR2(20)

Untitled (SPOT_RANK)

  • Field (SPOT_ID) — INT — Primary key
  • Field (RANK_COMP_ID) — INT — Primary key
  • Field (REG_DATE) — DATE

Untitled (ITEM)

  • Key (ITEM_ID) — INT — Primary key — NOT NULL
  • Field (GROUP_ID) — INT
  • Field2 (SPOT_ID) — INT
  • Field (REG_ID) — VARCHAR2(20)
  • Field (REG_DATE) — DATE
  • Field (MOD_DATE) — DATE
  • Field (LIKE) — INT
  • Field (CONTENTS) — VARCHAR2(500)
  • Field

Untitled (LIKE)

  • Field (ITEM_ID) — INT — Primary key
  • Field (REG_ID) — VARCHAR2(20) — Primary key

Untitled (PHOTO)

  • Key (ITEM_ID) — INT — NOT NULL
  • Field (PATH) — VARCHAR2(500)

Untitled (COMMENT)

  • Field (ITEM_ID) — INT
  • Field (REG_ID) — INT
  • Field (REG_DATE) — DATE
  • Field (MOD_DATE) — DATE
  • Field (CONTENTS) — VARCHAR2(500)

Untitled (TAG)

  • Field (GROUP_ID) — INT — Primary key
  • Field (TAG_NAME) — VARCHAR2(100) — Primary key