soonmile

Tables (4)

Group (Untitled2)

  • group_id (Key) — number(10) — Primary key — NOT NULL
  • owner_id (Field6) — varchar2(50)
  • group_name (Field) — varchar2(30)
  • is_public (Field2) — char(1)
  • group_intro (Field3) — clob
  • group_profile (Field5) — varchar2(50)
  • invite_code (Field7) — varchar2(10)
  • status (Field8) — number(1)
  • create_at (Field4) — DATE
  • update_at (Field9) — DATE
  • Field10

Group_User (Untitled3)

  • user_group_seq (Key) — number(15) — Primary key — NOT NULL
  • group_id (Key2) — number(10) — Foreign key → Group.group_id — NOT NULL
  • user_id (Key3) — varchar2(50) — Foreign key → User.user_id — NOT NULL
  • role (Field) — char(1)
  • join_at (Field2) — DATE
  • status (Field3) — number(1)
  • Field4

Location (Untitled4)

  • location_id (Key) — varchar2(50) — Primary key — NOT NULL
  • user_group_seq (Key2) — number(15) — Foreign key → Group_User.user_group_seq — NOT NULL
  • group_id (Key22) — number(10) — Foreign key → Group_User.group_id — NOT NULL
  • user_id (Key3) — varchar2(50) — Foreign key → Group_User.user_id — NOT NULL
  • group_id (Field) — number(10)
  • user_id (Field2) — varchar2(50)
  • name (Field3) — varchar2(100)
  • latitude (Field4) — number(10,7)
  • longitude (Field5) — number(10,7)
  • address (Field6) — clob
  • description (Field7) — clob
  • rating (Field8) — number(1,1)
  • create_at (Field9) — DATE
  • status (Field10) — number(1)

User (Untitled)

  • user_id (Key) — varchar2(50) — Primary key — NOT NULL
  • user_pw (Field) — varchar2(20)
  • user_name (Field2) — varchar2(10)
  • user_phone (Field3) — number(11)
  • user_profile (Field5) — varchar2(150)
  • status (Field6) — number(1)
  • reg_date (Field4) — DATE
  • update_date (Field7) — DATE
  • last_login_date (Field8) — DATE
  • Field9