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